Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have below script , which can filter BRAND_SUB=HAKKO from sales Table :-
NewFilteredTable:
NOCONCATENATE
LOAD *
RESIDENT sales WHERE BRAND_SUB='HAKKO';
DROP TABLES sales;
In my QVW file i have 2 table , which is ARSummary Table , and i also want to filter another field , SEGMENT=Other.
Hope some one can advise me how to modify the above , so that it can filter more then 1 table.
Paul
remove noconcatenate
while loading the 2 table u have to apply where clause; other than that i dont think some possibility exists.
can u attach qvw?
Hi,
can you attach your application.
you can join the two tables and then you can filter on the fields from the two tables.
It would be nice if you can post a sample application or post your script with the details of your field that you want to filter
hth
Sasi
hi paul,
try below code if key fields are matching:
NewFilteredTable:
NOCONCATENATE
LOAD *
RESIDENT ARSummary WHERE TERMS='30 DAY';
DROP TABLES ARSummary;
join(NewFilteredTable)
NOCONCATENATE
LOAD *
RESIDENT Q_DOD_2015 WHERE GROUP='BP';
DROP TABLES Q_DOD_2015;
Final:
NOCONCATENATE
LOAD *
RESIDENT NewFilteredTable
WHERE TERMS='30 DAY' and GROUP='BP';
DROP TABLES NewFilteredTable;
Regards
Neetha
Hi sir
I got error msg
remove noconcatenate
Hi Sir
Thank you very much.
Paul
Hi Neetha
When you give the the script , you did not get my raw data to test your script right ? May i know how to train yourself to be able to do this ?
Paul