i have 1 table which is contain South, North, West, East data,i want to show data for only North region but i dont want to used where condition in it then how it is possible by using optimize way.
We have different approach even without WHERE clause, Can you explain proper manner whats your intention. Does this is Field or Some Value?
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
First load the value through inline table which you want to filter
Region:
LOAD * inline [
Region
North ];
Data:
LOAD *
FROM Table
where exists (Region);
Note:
Field Name of inline table should match with the name in Actual table
If in your data table region field value in upper case, in inline table also you need to write value in upper case.
In above table only rename field is allowed to make the load optimize (if condition or any operation on field is not allowed for optimize load). where exists (Region) is already optimize.
I hope he was not aiming for an single answer but rather for a better and deeper understanding on your Qlik script skill level by seeing how you were reasoning around optimized loads, where clauses and data modelling.
There is some basic strategies I use when loading big amounts (>50m rows) of data as fast as possible into QV.
1. Load biggest tables first
2. Always do optimized loads first, and after (if needed) load them resident with complex where clauses.
3. Drop unused tables asap
4. Drop unused fields asap
5. Group by and join with as little data as possible as late as possible.
There are a lot if details on every step, especially step 2: Where exist can sometimes work, still keeping optimized load. Concatenate can be optimized in some scenarios.
