2 Replies Latest reply: Apr 19, 2012 10:06 AM by benjmoff RSS

    Load Script - create a new field in the script

      Hello,

       

      I'm not sure on the correct terminology but I would like to do the following.....

       

      I have a list of customer account numbers (User_Cust_Code)

       

      I would like to create a field which is basically customers in the group and customers not in the group.

       

      I can do this in the load script with:

       

       

      If(User_Cust_Code=101 or User_Cust_Code=102 or User_Cust_Code=103, 'Group' , 'Not Group' ) as Grouped_Users

       

       

       

      This is ok if I only have a small amount of customers that aren't going to change, but the group will be bigger and can change....

       

      SO!!! I would like to use a spreadsheet with a list of customer accounts in and use this instead of listing the accounts manually.

       

      Any ideas how to do this would be greatly appreciated.

       

      Thanks,

       

      Ben.