Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sspawar88
Creator II
Creator II

if column name changed does this logic work?

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.

4 Replies
Chanty4u
MVP
MVP

yes it wll not work ,  you need to rename the column in qlik and reload.

sspawar88
Creator II
Creator II
Author

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?

Chanty4u
MVP
MVP

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.

sspawar88
Creator II
Creator II
Author

Can you please elaborate this with above small example so that I can understand what you are suggesting