I have a dateset that is received with field headers in column 1 and data in column 2-X (varable amount of data elements).
I need to be able to dynamically transpose that dataset (flipping columns and rows) so the data elements are stored in rows and the field headers are Row 1 allowing me to easily append data refreshes regardless of how many columns are included in the source.
The ETL pivot options as well as the megatable card options require I know ahead of time how many columns of data elements exist within the dataset prior to transposing/pivoting. That will vary for each refresh.
By creating a Dynamic Transpose tile to the Magic ETL list I could build an ETL workflow that transposes the dataset when it comes in; then appends the corrected table structured data to a repository dataset I can then use to drive reporting. Currently there is no way to use data that is structurd this way; and I cannot control how the data I receive is formatted.
