Skip first N columns

Hi Team,

How can we skip first N columns in Alteryx like how we have Skip N rows in Sample tool.

In my case,

1. I've data with 10 fields in a File A where actual data starts from 4th column which means first 3 columns are junk. So, I've pull data from column 4.

2. File B has 15 fields and actual data starts from column 8 which means first 7 columns are junk.

So, how can we achieve this, and this has to be dynamic since I've several files and each file has different structure.

Workflow

Developer Tools

Dynamic Processing

Accepted answers

BS_THE_ANALYST

@Qiu you will like this solution:

before:

After

We can make use of:

All the best,
BS

All comments

binu_acs

@Shaaz Do you have any specific column names for your files and are they in order?

Shaaz

@binu_acs No, they are no specific column names. Column can be anything in each of the file. In our case, for example client would say don't consider 1st 4 fields in File A and don't consider first 7 columns in File B and so on.