Solved
Forum Discussion
Abhishek_117 - I think the answer you're looking for is already an option in the CSV Parser snap. In the "Header size error policy", select "Trim record to fit header". This will ignore any extra columns in the input data.
Hope this helps!
Abhishek_117
3 years agoNew Contributor II
Hi koryknick ,
Thanks For suggestion, but its working partially. Like I have added irrelevant columns in beginning and its adding data of relevant columns to irrelevant columns and due to which extra columns which are relevant they are becoming null.
Here Tik-Tok,Balance and Results are irrelevant column but when i select "Trim record to fit header" its taking data's from right column i.e CustomerKey,Prefix etc to left columns(which are irrelevant).I want to delete those column