NIFI- CSV data and CSV schema in different files

[#1]

Hi, I am new to NIFI and I am still learning. My question is I have a CSV file where the data resides in pipe seperated and schema of this data is present in seperate file as below fromat

Schema: This is tab seperated

Tablename col1 datatype

Tablename col2 datatype

tablename col3 datayype

Datafile format: col1|col2|col3

I have to match schema and data accordingly and then load that data in sql db table. We will have several source files

and several header files.

Thanks,

Asmath

[#2]

Use InferAvroSchema Nifi Processor, which helps you to convert your csv file into avro schema, and then use that schema in your controller service registry.