5 Replies Latest reply: Apr 5, 2018 3:41 PM by Kailash Kotak RSS

    Adding a column while loading data

    Kailash Kotak

      Hello,

       

      So I am loading data from 12 different files (1file for each month). However the file does not have any specific date/month/time attribute. I want to add a static column with Month Name. Following is my sample of my Load. Can someone help me with adding a column while i load the data ?

       

      Load

      First Name

      Last Name

      Grade

      Request Number

      Unique ID

      Month (How to add this with a static value of January)

       

      From

      abc.xls

       

      Can someone help me with adding the month column as shown above with a static value ?

       

      Regards,

      Kailash Kotak