I have a csv file. Number of lines = 13. On the output, I keep getting one line per page. I just want to keep the header + the first line so the output is one page. How do I do that ?
In your DataMapper configuration, make sure to tick the First row contains field names option, then set the number of Records to the highest number of lines your CSV may contain.
First row contains field names is already ok. If I set to the highest number of lines, I will get all lines. I just need 2 lines (the first containing field names + one line)
Well then set the Records to 1 and then ignore the rest of the records by inserting a condition at the start at the process that checks if the record index is higher than 1:
ok great thks Phil…