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

[#1]

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

(qvd)

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

Your help is greatly appreciated...

[swuehl]

You can create new fields like

Won_Data:

LOAD [Opportunity Id],

       [Won  Reasons] & ',' & [Won Reason 2] & ',' & [Won Reason 3] as [Won Reasons combined],

       ...

text literals would be enclosed in single chars, concatenation operator is &

You can use a conditional function to check for conditions:

Won_Data:

LOAD [Opportunity Id],

       If(not isnull( [Won  Reasons]) or not isnull( [Won  Reasons 2]) or not isnull( [Won  Reasons 3] ),

          [Won  Reasons] & ',' & [Won Reason 2] & ',' & [Won Reason 3]

     )  as [Won Reasons combined],

       ...

[#3]

Thanks much...   Greatly appreciated