1 Reply Latest reply: Feb 15, 2018 12:40 PM by Sunny Talwar RSS

    How to pull dynamic field names in load script

    Abhay Sudhakaran

      I need to pull data from a data file which will have changing column names.

       

      Example:

      NameDeptJobJan 2018Feb 2018Mar 2018Apr 2018May 2018Jun 2018
      JohnFinanceJ110020213122121213
      BerryTaxJ2100200200200200200
      CharlieITJ3200120200200250120
      JackFinanceJ4500300200200100300

       

       

      The first few column names will remain the same, but the Month-Year columns would keep changing because this is a rolling 12 or 15 month file.

      What I am trying to achieve is to have a dynamic logic so I can pull all fields (with field names) and also derive month year values from the column headers, to later use them in the calendar & dates.

       

      NOTE - CROSSTABLE might not be the answer, because the user wants to see a separate column for each month.

       

      Any help is appreciated. Thanks