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.
Solved! Go to Solution.
Hi @mjh418
This can be easily done using dynamic rename tool and option take field name from first row.
Workflow:
Hope this helps : )
@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 |
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.