topic Re: During script load I would like to include a made up field from other fields in QlikView

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

Thu, 26 Jan 2017 20:26:43 GMT

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 — Thu, 26 Jan 2017 21:22:17 GMT

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],

...

Fri, 27 Jan 2017 12:51:45 GMT

Thanks much... Greatly appreciated