Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
......
where not wildmatch([Field A], '*account adjustment*')