Avatar

Level 1

I have a file import that has x-number of columns. I want to create an automated enumerator that updates it's values based on the column-labels of the import files.

But in order to do that, I need to transpose the column lables of the import file to values of a single column.

So - f.ex. the file looks like this:

Column1Column2Column3Column4Column5

Data 1

Data 2Data 3Data 4Data 5
Data 1Data 2Data 3Data 4Data 5
Data 1Data 2Data 3Data 4Data 5

I want to get this kind of result:

Label of Columns
Column 1
Column 3
Column 3
Column 4
Column 5

So I could then add the values of "Label of Columns" as Enumerator values to my enumerator.

How to do this (either via normal activities - which I doubt will bend to this - or with JS-code).

The main criteria are:

- Having a single column with the names of the columns of the imported file

- The number of columns can vary in the import file.

- Mikael -