Trim data after binary load

[#1]

I am building a setup where I have Document A storing all loading and transformation of data for the company, then I do a binary load to Documents X, Y and Z all of which have very unique requirements. The reason is that anytime someone looks for sum(Sales) i want the answer to be the same so all the rule on defining what "Sales" is are in one place.

I would like to do a binary load (Load all from Document A) then delete all the rows from the table "OrderLines" where business division not equal to X, Y or Z.

Is this possible, or am I trying to stretch the usage of Binary load too far?

Thanks!

[Anonymous]

Philip

That all sounds perfectly sensible so go for it.

Best Regards,     Bill

[#3 · Accepted solution]

Yes its possible as stated by Bill Markham.

This code might help.

Rename table OrderLines as Temp;

OrderLines:

noconcatenate

Load * Resident Temp

where not match(Field,'X' ,'Y' ,'Z' ) ;

Drop table Temp;

Thanks

AJ