Start Data Import on Line but when exporting export the whole excel

Question

I have an excel input where the table headings begin from row 7 so I have put "Start Data Import on Line" as 7. But the rows 1 to 6 have important data and would like to include rows 1 to 6 as well in the output after alteryx has finished running the workflow on data from row 7.

Is this a possibility and if so how?

Pawel_Paleczny · Accepted Answer

Hello ndubal,

Import whole Excel file and next use RecordID tool, next Filter tool and filter rows from 1 to 6 (below 7) it gives 2 data streams, on the end combine them using Union Tool and in Select tool just remove RecordID column. Please let me know if that solution sounds good for you.