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

      Hi,

       

      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:

       

      IF

            (

            Tier2_Org_Area = 'Europe & Digital' OR

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

      IF

            (

             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?

       

      Thanks

       

      Sunil