Set analysis in load script?

[#1]

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!

[jaimeaguilar]

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

[#3]

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

[maxgro]

......

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