2 Replies Latest reply: Jan 27, 2017 7:51 AM by Rich Coe RSS

    During script load I would like to include a made up field from other fields

    Rich Coe

      Hello, I'm fairly new to QlikView and would include a made up field from other fields.

       

      script data load with 23 fields and include this new field  [Won Reasons combined]

       

       

      Won_Data:

      LOAD [Opportunity Id],

       

      [Won Reasons combined] = [Won  Reasons] & ", " & [Won Reason 2] & ", " & [Won Reason 3]

           WHERE  ((([Won  Reasons]) Is Not Null Or ([Won  Reasons])=""))

                OR ((([Won Reason 2]) Is Not Null Or (.[Won Reason 2])=""))

                OR ((([Won Reason 3]) Is Not Null Or ([Won Reason 3])=""));

       

      [State],

      [zip],

      [Solution],

      [Won Reasons],

      [Won Reason 2],

      [Won Reason 3]

       

      FROM

      [C:\_Work\Master_Data.qvd]

      (qvd)

      WHERE WildMatch([Segment Detail], 'SMB Focus') And WildMatch([Fiscal Period], '0','1');

       

      Your help is greatly appreciated...