QlikSense Script Inquiry

[qwebnm]

I have a question regarding the QlikSense script.

I am using a script similar to the one attached below:

LOAD empno,
ename,
hiredate,
sal,
// test,
deptno;

I am a bit confused and wonder if the script above is necessary.

In my opinion, applying the above script doesn't seem to make any difference, and I believe it won't generate any data.

It appears to me that two scripts with apparent duplication have been written.

Is my assumption correct? Or is there a reason for using it this way?

I suspect it might be a developer's mistake.

Additionally, in the script provided by the actual database connection, I noticed that it also includes similar lines.

Is there a specific reason for adding these Load statements? Or are they unnecessary?

If possible, I would appreciate your feedback and guidance on this matter.

Thank you.

[qwebnm]

Additionally, in the script provided by the actual database connection, I noticed that it also includes similar lines.

Is there a specific reason for adding these Load statements? Or are they unnecessary?

[Adam_Romanowski]

It's preceding load. As you can see, db connector generates code for first load to make calculations/transformations using qlik engine, while the second load is just SQL code to get data from database.

If you don't need to perform transformations for data already loaded into Qlik, you can remove first LOAD.

More details:

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