Dynamically select column names

[Shaaz]

Hi,

I've 2 excel files as per below.

1st File:

Column name starts at first row

2nd File:

Column name starts at second row

How do I dynamically select column names from both these files ?

[atcodedog05]

Hi @Shaaz 

I wouldnt call it dynamic but there is an option where you set from which line to import. With that the first line becomes column headers.

Hope this helps🙂

[Qiu]

@Shaaz 
I also agree that there is not really fully dynamic way to do this, since we need some triger at least.
@atcodedog05 way is to do it at the front, and you can choose to use dynamic Rename at end.

[DavidP]

Hi @Shaaz 

You could load both files with the option "1st line contains headers" unchecked, then use a Data Cleanse tool with the Option "Remove null rows" checked or a filter tool to remove the row above the field names so that the field names are in the 1st line and use a Dynamic Rename tool to pick it as the field names.