topic Re: Split table in two under a condition in QlikView

Split table in two under a condition

Sun, 28 Apr 2013 09:03:52 GMT

Hi,

I have a table (attached) called 'Table_All' with two fieds, 'A' and 'B'.

I would need to get a new table from resident 'Table_All' which includes al the rows where where 'B' is different than all the values in 'A'.

That is the resulting table should have only values of 'B' differents than all the values in 'A'.

Obviously " RESIDENT Table_All WHERE 'B'<>'A' " did not work.

I would appreciate any idea.

Thanks

Re: Split table in two under a condition

Miguel_Angel_Baeyens — Sun, 28 Apr 2013 18:07:11 GMT

Hi,

The script for this kind of loads usually follows this way:

TableAll:
LOAD A AS OriginalA,
     B AS OriginalB
FROM File.qvd (qvd);
OnlyBDifferentThanA:
NOCONCATENATE LOAD A,
     B
FROM File.qvd (qvd)
WHERE NOT EXISTS(OriginalA, B);
DROP TABLE TableAll;

Hope that helps.

Miguel