Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Assume a QVD of 10 GB data with 15 field/columns, one of the field/column named 'Countries' .Here 'Countries' field contains 20 distinct countries. Scenario here is to apply some transformation to filter only 5 countries and still to maitain it as optimized load.
Thanks in advance.
TempCountries:
LOAD * Inline [
Country
US
France
Germany
];
Facts:
LOAD * From myqvd.qvd (qvd)
Where exists(Country);
-Rob