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.