Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When creating your scripts for loading multiple tables that may include concatenations and joins, is there a required order for the statements given the bottom up script reading that Qlik Sense performs? If you have a join and a concatenation on a table, how do you write the order of this steps?
I'm sure there are plenty of ways to accomplish this but keep in mind you can use Resident Loads to manipulate tables in memory. Could do something like:
Load from Data Source
Join with other data using Resident Load
Concatenate using Resident Load
Drop Original Table
I'm sure there are plenty of ways to accomplish this but keep in mind you can use Resident Loads to manipulate tables in memory. Could do something like:
Load from Data Source
Join with other data using Resident Load
Concatenate using Resident Load
Drop Original Table
You would order the transformation in the order you need to perform to meet the expected output