Discussions
-
Add a Dynamic Transpose Tile to Magic ETL
my source data comes in with field headers in column 1 and all data elements in columns which vary in legth each refresh. Since I am unable to know ahead of time how many columns of data elements will exist within a given refresh, I am unable to use the megatable card or the dynamic unpivot tile options current at my…
-
Add a Dynamic Transpose Tile to Magic ETL
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…