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 disposal. If a Dynamic Transpose tile could be created within Magic ETL we could easily flip columns to rows resulting in the field headers received in column 1 now in row 1 and data elements receive in a varible quantity of columns now in rows as are needed to drive reporting from that dataset.
