How to delete first 50 columns for input files with different data format?

skotian1289

Hello All,

I am a new user and this is my first time post.

I am trying to build a workflow where i need to delete the first 50 columns of my Input file. My input files will differ everyday and column headers wont be the same or will not be in same alignment  hence the select/deselect field tools is not helping me when i tried because the workflow tried to locate the field name in my next input file.

See below example of what I am trying to say:

Lets say we are trying to build a workflow to delete first 5 columns of input file doesn't matter what the headers are just delete first 5 columns.

Input File 1: 

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6	Column 7	Column 8	Column 9	Column 10	Column 11	Column 12	Column 13	Column 14
1	2	3	4	66	77	88	99	44	55	55	66	77	33

Output for File 1:

Column 6	Column 7	Column 8	Column 9	Column 10	Column 11	Column 12	Column 13	Column 14
77	88	99	44	55	55	66	77	33

Input File 2:

Column 7	Column 8	Column 9	Column 10	Column 11	Column 12	Column 13	Column 14	Column 1	Column 2	Column 3	Column 4	Column 5	Column 6
88	99	44	55	55	66	77	33	1	2	3	4	66	77

Output for file 2:

Column 12	Column 13	Column 14	Column 1	Column 2	Column 3	Column 4	Column 5	Column 6
66	77	33	1	2	3	4	66	77

Please assist .

Regards

SK

JosephSerpis

Hi @skotian1289 I used your file to show how the workflow works and attached an Alteryx package so you can see how it works

Fields_05062020.yxzp