12 Replies Latest reply: Oct 12, 2018 11:22 AM by Lisa Valpassos RSS

    Convert date rows into date columns

    Lisa Valpassos

      Hi folks,


      I have a file with this structure (ignore dummy values):




      And I simply want to convert the Date rows into various columns (one column for each year-month) because I have the requirement to see the data in a table with this format. I cannot use Pivot Table because pivot table does an aggregation (the Totals rows) that, for this purpose, is not accurate.


      I have tried the Generic Load but I'm not getting anything. I have to use a resident and preceding load with it and it keeps saying "Table 'myGenericTable' not found"


      Any help?