-
Re: Where Condition from another QVD
Hari Prasath Dec 26, 2017 4:12 AM (in response to Janani Reddy )- Load the full qvd file,
- use resident and drop the qvd table
-
Re: Where Condition from another QVD
Janani Reddy Dec 26, 2017 4:21 AM (in response to Hari Prasath)Hi Hari, I did so but i was unable to get what i wanted. Can you elaborate with the script please
-
Re: Where Condition from another QVD
Mohammed Mukram Ali Dec 26, 2017 4:25 AM (in response to Janani Reddy )Hi,
Use
Where Exists(Product );
-
Re: Where Condition from another QVD
Mohammed Mukram Ali Dec 26, 2017 4:26 AM (in response to Mohammed Mukram Ali)Hi,
LOAD * FROM [lib://QVD/Loans.QVD] (qvd) ;
LOAD * FROM [lib://QVD/Product.QVD] (qvd)
Where Exists(Product );
but make sure to load Product table after Loans table.
-
Re: Where Condition from another QVD
Janani Reddy Dec 26, 2017 4:37 AM (in response to Mohammed Mukram Ali)Thanks for the quick reply this worked
-
-
-
Re: Where Condition from another QVD
Hari Prasath Dec 26, 2017 4:38 AM (in response to Janani Reddy )Loans: LOAD * FROM [lib://QVD/Loans.QVD] (qvd) ;
Product_Loan_Mapping: Mapping Load Product, 'Mapped' as Flag resident Loans;
Product_Temp:
Load *, ApplyMap('Product_Loan_Mapping', Prodcut, 'N/A') As Mappings;
LOAD * FROM [lib://QVD/Product.QVD] (qvd) ;
NoConcatenate
Product:
Load * resident Product_Temp where Product = "Mapped";
-
Re: Where Condition from another QVD
Hari Prasath Dec 26, 2017 4:39 AM (in response to Hari Prasath)Drop table Product_Temp;
-
-
-
Re: Where Condition from another QVD
omar bensalem Dec 26, 2017 4:35 AM (in response to Janani Reddy )try sthing like this:
Loans:
LOAD ..., Product as ProductLoan FROM [lib://QVD/Loans.QVD] (qvd) ;
Products:
LOAD * FROM [lib://QVD/Product.QVD] (qvd) ;
Final:
Load Product as ProductLoan , Address Resident Products where Exists (ProductLoan, Product );
Drop Tables Loans, Products;