6 Replies Latest reply: Nov 18, 2010 3:51 PM by Ellen Blackwell RSS

    Change value of field based on combination of two separate dimensions

    Ellen Blackwell

      In my load script, I would like to do accomplish this:

      IF LOB = 4105 or 4106 or 4107 or 4110

      AND [Line Description] = P211103 - PolChgs-Surr Charges

      CHANGE [Line Description] to P211103 - PolChgs-Surr ChargesDIR

      How do I script this functionality into the following load script?

      This community's response always amazes me, so I am going to say, "Thank you!" in advance. Ellen

       

       

       

       

      Plan:

      LOAD

       

       

      [Account and Name] as [Line Description],

      [Combined Product] as Subseg,

      LOB,

      Date

       

       

      num

       

       

      FROM

      [SOE Plan.xlsx]

      (

      ooxml, embedded labels, table is [Q1 2009]);

       

      ooxml, embedded labels, table is [Q1 2009]);([Amount * -1], '#,##0.##', '.' , ',') as [Plan Amount]([Last Day of Query Period]) as [As of Date],