7 Replies Latest reply: Aug 13, 2015 10:16 AM by Sunny Talwar RSS

    Problem with writing field values from another field

    Shan Ahmed



      I have three columns in excel file. One is InvoiceID, ItemID and another is Sales Description. For InvoiceID which starts with ''SI" does not have an ItemID if you look at the excel file. Please see Sheet1 tab in excel file


      What i am trying to get is the InvoiceID that starts with "SI" will bring the Sales Description into ItemID and make it an ItemID for that InvoiceID. Please see the Sheet2 tab.


      What would be the correct script for this to achieve the goal?

      I tried with this: If (left(InvoiceID,2)=’SI’ and ItemID=’’,SalesDescription,ItemID) as ItemID


      Thanks in advance.