Discussion board where members can get started with Qlik Sense.
Someone handed me this. What I can see is.
1. Ordered_mobile_base = all rows from mobile_base but only matches from mobile_latest_id.
What does the where clause do for the last table? I've never seen a syntax like even with SQL.
Why even do the first table if you just want the lastrow?
All referenced table and fields exist.
DROP TABLE [mobile_base];
Drop Table [mobile_latest_id];
//find the latest records of inspex data
Drop Table [Ordered_mobile_base];
Go to Solution.
The first step joins a table of data with the id of the latest record from a latest record identification table so you have a mix of old and new records in the resulting dataset
The second step returns only the data for just the latest records.
The where clause compares one field in the table with the other and where it matches it brings it through in the results.
Pretty standard SQL.
Usually in Qlik we used the EXISTS function to filter in/out the matches and with fewer steps.
This seemed a little round-about method but I understand.
Yes would do the same thing.