The issue here is I have a .csv file. I need to perform the above operation in that file. I think tFixedFlowInput is not suitable for reading from a file. Am I correct?
Your answer is correct. But in my case, my file contains about 60 headers and 1000s od data. So it's practically not feasible to map all the columns in the above mentioned way. And I like to have a generic method so that any CSV file in the above format but with different header names should also be processed.
60 columns is not so huge. Also, the volume of data doesn't matter and you don't have to worry about the header line as soon as you use constant values for the target. I recommand you to keep simple using standard components. Else, for this case you will have to do it yourself using a tJavaRow component (I'm afraid).
The problem is that I've to apply this to different csv files with different number of columns and differnt header names. And I'm don't really understood "you don't have to worry about the header line as soon as you use constant values for the target.". Could you please elaborate or give an example?
