topic Set analysis in load script? in QlikView

Set analysis in load script?

Tue, 21 Oct 2014 17:49:00 GMT

Hi all -

I'd like to load a subset of a field in my load script, but I'm not sure how to do it. I would like to load all lines from "Field A" that do not contain the phrase "account adjustment" (*account adjustment*) and we can just name this new field "Field B." How would I go about doing this? Thanks!

Re: Set analysis in load script?

jaimeaguilar — Tue, 21 Oct 2014 18:14:33 GMT

Hi,

Set Analysis cannot be used in Load Script, it is a front-end-only feature. To do what you describe, your script may look like this:

TableName:

LOAD [Field A] as [Field B],

//Any other fields

From SourceTable

where not wildmatch([Field A], 'account adjustment');

The (not) wildmatch will search for string coincidences, and because it has a not before it will discard the coincidences and load everything else.

regards

Re: Set analysis in load script?

Tue, 21 Oct 2014 18:17:17 GMT

Hi Marco,

You don't need Set Analysis (nor you could use it). While you script the Load statement use the where clause to restrict the table to have records satisfying the given condition. For renaming, you could do it directly in load script as

TableName:

Load

FieldA as FieldB

From <Source>

Where <Condition>

Thanks,

Madhu

Re: Set analysis in load script?

maxgro — Tue, 21 Oct 2014 18:21:54 GMT

......

where not wildmatch([Field A], '*account adjustment*')