Discussion board where members can get started with Qlik Sense.
I am doing a resident load, but for some reason it's not recognizing the "Workday" table it just keeps saying table not found. There is a table called Personal earlier in the script that I'm resident loading from. Please let me know if you can help:
Drop Table Personal;
Left Join (Workday)
Go to Solution.
If you load a table from a resident table and you keep all the fields the same it will not create a new table but rather add all the records to the first table.
You can avoid that by using a NOCONCATE prefix like this:
Noconcatenate LOAD DISTINCT