topic Re: Trim data after binary load in QlikView

Trim data after binary load

Fri, 31 Jan 2014 01:13:42 GMT

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!

Re: Trim data after binary load

Anonymous — Fri, 31 Jan 2014 17:44:34 GMT

Philip

That all sounds perfectly sensible so go for it.

Best Regards, Bill

Re: Trim data after binary load

Fri, 31 Jan 2014 17:53:24 GMT

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