3 Replies Latest reply: Oct 20, 2011 2:59 AM by Anand Chouhan RSS

    Help with IF statement and adding additional columns in script

    Sunil Kenth



      I would like some help with IF syntax.


      I am trying to add an additonal column called 'T2' in my table through the load script, this is what i have so far:




            Tier2_Org_Area = 'Europe & Digital' OR

            Tier2_Org_Area = 'USA', 'RED') as T2,



             Tier2_Org_Area = 'Africa', 'Blue')

        as T2



      However when i reload the data i get an error message saying column names cannot be the same, I was hoping the second IF statement would just be concatenated to the first T2 column?



      Any ideas?