I am trying to build a process of extracting some data from Qlik DataMarket and I am trying to understand the concept behind the automatically generated extraction script.
Here are the options I've selected in the DataManager:
Just want to get the "Most Recent" (whatever that means) data for Chicago, IL.
Based on these selections, Qlik has generated the script for me:
[Weather in 50 cities worldwide]:
"Average of the 24 hourly cloud cover observations as a percentage";
SQL SELECT * FROM "52kv"
WHERE "8vq5" = "1c"
AND "8vq6" = "p"
AND TIME = MOST RECENT;
My question is: WHY SO COMPLICATED WHERE CLAUSES????
I am assuming that "8vq5" = "1c" means "COUNTRY" = "US" and "8vq6" = "p" means "CITY" = "CHICAGO",
And "MOST RECENT" is simply the last day!
Here is how the DM Where Clause looks like for the "all inclusive" case:
WHERE "8vq6" = "p.22.214.171.124.d.n.11.y.z.10.1b.l.126.96.36.199.g.t.b.5.8.s.i.k.q.m.o.6.a.f.c.j.h.w.1.1a.1c.3.r.u.15.1d.x.19.4.2.v.e"
I could not find any information about mapping these codes to the "normal and readable" conditions.
I am actually trying to build a script to extract a specific set of data (for flexible Date ranges and for specific locations) and I need to have these codes mapped to my other fields in other tables.
I know I can extract the WHOLE data set into QVD and load the specific set from there, but I am trying to optimize my script loading and this approach is definitely not the best one.
Any suggestions will be really appreciated!