Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Emp:
LOAD
Name,
ID,
Location
FROM
TestData.xlsx
(ooxml, embedded labels, table is Sheet1);
if ScriptError= 11 then
EXIT Script;
ELSE
EXECUTE cmd.exe /c md "A" 2> nul;
EXECUTE cmd.exe /c MOVE /Y "TestData.xlsx" "A\";
Condition : If any Column name changed in Source file. this logic has to stop moving file from one location to another and log file has to show the unmatch column name.
yes it wll not work , you need to rename the column in qlik and reload.
Actually, I want to create one application which catch any change in source file. can you have nay alternate way ?
Can we populate changes in source file on dashboard? is there any way?
yes you can load below the script and what ever the field you modified /changed give the column name same and copy the path and place the same and reload.
Can you please elaborate this with above small example so that I can understand what you are suggesting