I have a csv file that contains dynamique informations on header that we dont know number of line, and then i have columns like that :
line1 Country : French;
line2 Date : 27/04/2017;
lineN (Can be other informations)
I want to keep just fields concerned ID,Product and size because i use them on a Tmap
Solved! Go to Solution.
If you don't know header records count and still need to filter header records and load only valid data into target then try below. Here i assumed ID valid value is numeric.
In tMap, used filter condition based on ID is numeric. If it is numeric then pass else reject.
@vboppudi, Hazardous (IMHO) as you don't know what may arrive before the real header.
The solution I proposed works at any time (any rows number, any content).