Qlik Sense Script order

[hboyles]

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?

[Qlik_Eric_Thomas · Accepted solution]

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 

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/load-data-...

[vinieme12]

You would order the transformation in the order you need to perform to meet the expected output