Thanks for this, but I feel like this solution is a bit unworkable for a table in which you don't know what all the field names will be. For example a table I am looking at has two columns - one called variableName and another with variableValue. Not the best table I know, but this is what I have to work with.
So if my table is hundreds of lines long, with an unknown number of different variable names, I wouldn't be able to list them all in the data load editor.
I was hoping to find something like the proc transpose which SAS offers, but in the Qlik Sense universe. That is pull in the data, make the variableName values the headers for the resulting table and the values populate.
id | variableName | variableValue
001 | name | Adam
002 |name| Sarah
id | name | age| city
001 | Adam | 33 | London
002 | Sarah | 34 | Paris
But this is for a table of unknown size with an unknown number of variable names.