filter excel columns before it going to collection
- Thread starter arunkiran
- Start date
Hi arunkiran,
As a quick fix without adding any new Code stage you can make use of the Copy Paste Worksheet Range to copy all your required columns to another temporary sheet, then getting that sheet as Collection and then clearing the temporary sheet.
In above example, A, C and E columns will be copied from Sheet 3 to Sheet 4.
You can then get Sheet4 as collection and clear Sheet4 once done.
As a quick fix without adding any new Code stage you can make use of the Copy Paste Worksheet Range to copy all your required columns to another temporary sheet, then getting that sheet as Collection and then clearing the temporary sheet.
In above example, A, C and E columns will be copied from Sheet 3 to Sheet 4.
You can then get Sheet4 as collection and clear Sheet4 once done.