Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
hboyles
Contributor
Contributor

Qlik Sense Script order

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?

Labels (1)
1 Solution

Accepted Solutions
Qlik_Eric_Thomas

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-...

Sr. Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!

View solution in original post

2 Replies
Qlik_Eric_Thomas

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-...

Sr. Technical Support Engineer with Qlik Support
Help users find answers! Don't forget to mark a solution that worked for you!
vinieme12
Champion III
Champion III

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.