Discussion Board for collaboration on QlikView Scripting.
I have two tables with the following fields and data:
I have tried loading the first table in a temp table, then joining the second field with this table, and then doing a resident load in a final table using the following code:
AppName as [App Name Active]
Resident [(...another table)];
Document as [App Name Total]
resident [(...another table)];
[App Name Total],
[App Name Active]
Where [App Name Total] <> [App Name Active];
DROP Table temp;
Any ideas on why this is not giving me the correct output?
Go to Solution.
No Inline Load is not compulsory.
You can use something like
Load NAME2 FROM TABLENAME2;
NoConcatenate //Or you can avoid NoConcatenate also
Load NAME1 FROM TABLENAME1;
Load NAME1 as NAME3 Resident T2 Where Not Exists (NAME2,NAME1);
Try something like this
load * inline [AppsApp1App2App4] ;
load * inline [AllAppsApp1App2App3App4] ;
load AllApps as Inactive
where not exists(Apps, AllApps) ;
Load * Inline
Does an inline load have to be used? My sources are a excel file and a .txt file.
No , the load can be from any source. I simply used an inline load to create a simple example that others can use and test without any other data.