topic Re: if column name changed does this logic work? in QlikView

if column name changed does this logic work?

sspawar88 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: if column name changed does this logic work?

Chanty4u — Thu, 03 Aug 2017 09:46:56 GMT

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

Re: if column name changed does this logic work?

sspawar88 — Thu, 03 Aug 2017 09:52:24 GMT

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?

Re: if column name changed does this logic work?

Chanty4u — Thu, 03 Aug 2017 10:16:18 GMT

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.

Re: if column name changed does this logic work?

sspawar88 — Thu, 03 Aug 2017 10:28:27 GMT

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