Converting first row of data into column(Field) names

[mjh418]

Hi All,

The source file that I use for the workflow has column(field) names that are NOT fixed and may change depending on what the user is trying to extract. 

Because I don't want to hard code these and the user can't manually change the source file, I intentionally import it in a way that the field names become first line of DATA and the Field names are automatically populated as F1, F2, ... and so on (Please see below). This way I can manipulate the first line of data into a workable fixed field name by putting through some conditions first. 

My question is after I have dynamically renamed the first row of data into desired column/field names, how do i move (replace those F1,F2s) those into actual column names? If you can attach example/workflow, it would be greatly appreciated.

Please see below for example.

F1	F2	F3	F4
FieldName1	Fieldname2	Fieldname3	Fieldname4
12	22	17	7

Desired Outcome:

FieldName1	Fieldname2	Fieldname3	Fieldname4
12	22	17	7
xx	xx	xx	xx

Thank you so much for your time. 

[atcodedog05 · Accepted solution]

Hi @mjh418 

This can be easily done using dynamic rename tool and option take field name from first row.

Workflow:

Hope this helps : )

[mjh418]

@atcodedog05 wow thank you so much!

Sorry if I may bother you one more time, before all this, how can i take ONLY the FIRST ROW(to be fields) and turn that row into a single column?

[Field name]

Fieldname1

Fieldname2

Fieldname3

Fieldname4

[atcodedog05]

Hi @mjh418 

You can configure dynamic rename tool to "Take Fields from first row" refer the yellow highlighted in the image. This will take the first row as column names.