4 Replies Latest reply: Apr 20, 2017 3:01 AM by bharath godi RSS

    How to add calculated column using the calculated column

    Shubham Sharma

      Hello All

       

      I want to create a calculated column from an calculated column.

       

      Below is the example:

       

      TEST:

      Load [Name],

      [Date of Birth],

      if([Date of Birth]='','Null',[Date Of Birth]) as [DOB],           /* First Calculated Column*/

      timestamp([DOB],'YYYY') as 'Ýear',                          /* Second calculated column derived from First Calculated Column [Date of Birth] */

      month([DOB]/3) as 'Quater'                                     /* Third calculated column derived from First Calculated Column [Date of Birth]  */

       

      From

      [abc/test.xlsx]

       

       

      I am getting an error message as  [DOB] not found. But if i remove the second and third calculated columns then no error the script executes successfully.