I'm creating a table (let's say table "temp") and then concatenating on to temp using data from another source in my script load. In the concatenate() load, I use a where clause to tell QV not to pick up any rows where there is a "Total" string of any sort in column 1 (using where <> '*Total*'). My script looks like below:
Temp:
Load
some data...
...
From source1;
Concatenate(Temp)
Load
Additional data...
...
From source2
WHERE Field1 <> '*Total*';
For some reason, the script is ALWAYS loading the "Total" rows. If I change it to WHERE Field1 = '*Total*' the NONE of the line items from source2 will load. Any ideas why this is the case?
