Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dear Qlikers
Im working on some application in Qlik sense, i made several connections and loaded multiple data sources easily but suddenly the data load process is no longer working, with no errors but i get couldnt load data at the end of the load, this is happening to the new data and the old data ive already loaded, i tested the connections and they are working .
any idea what is the problem??
appreciate your help
Mina
Or use the EXIT SCRIPT; command and place after each data source load until you find the offending one.
Create a new app and Copy your connections and perform reload one at a time until you hit the step that is causing the error to troubleshoot your issue.
Or use the EXIT SCRIPT; command and place after each data source load until you find the offending one.
Hello Mena,
Trust that you are doing well!
I agree with Andy & Gareth! However, You can make use of TRACE statement in your script. Place the TRACE statement in between of different loads and check the reload timings.
Table1:
LOAD Field1,
Field2
FROM Table1;
TRACE "Table1";
Table2:
LOAD Field1,
Field3
FROM Table2;
TRACE "Table2";
Hope this will be of help.
Regards!
Rahul
Thank you Andy, i tried that after posting the issue and it worked perfectly.
thanks
Thanks Rahul, i will try that
Reagrds
alternatively you can use disconnect statement to when ETL of one data source is completed.
So QV won't get mixed up with multiple data source.