Custom Column Entry

[praneshsapmm]

Dear Community , 

I have this requirement of loading multiple excel files . Each file under column 'K' contains data with different column name . I would wish to load all the data from Column 'K' into a new custom column and thereafter reduce the first 3 characters from left from the data . 

Iam unable to do this since column name is different in each file . 

Any help .

[Blake · Accepted solution]

Hi @praneshsapmm - I'm not sure if I completely understand your question but it seems like you always want to bring column "K"  in to your workflow, without worrying about what the column is actually called. 

You can select option 6 in the input data tool that says "First Row Contains Data" which will always read your data in with serialized column headers. 

This will always give column K the name "F11" and you can select that field to work with. 

Thanks, let me know if this helps!

[Jonathan-Sherman · Accepted solution]

Hi @praneshsapmm,

I would take the approach of ticking "First Row Contains Data" to not automatically assign column headers:

This will create automatic column headers of F1, F2, F3 etc. Use a select tool to keep only F11 (Column K), untick "Dynamic And Unknown Fields" also, to ensure we never bring in new columns.

Finally, use a dynamic rename to take field names from first row of data.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[praneshsapmm]

Hello Jonathan,

It worked. Thankyou.

[praneshsapmm]

Hello Blake,

It works. Thankyou.