topic Re: script meaning in QlikView

script meaning

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

What is this script means, how it works?

IF vTable = 'ALL' OR vTable = 'TableA' THEN

[TableA]:

LOAD *

FROM

[$(QVDPath)A.qvd]

(qvd);

store [TableA] into [$(QVDPath)TableA.qvd] (qvd);

drop table [TableA];

[TableB]:

LOAD *

FROM

[$(QVDPath)B.qvd]

(qvd);

store [TableB] into [$(QVDPath)TableB.qvd] (qvd);

drop table [TableB];

[TableC]:

LOAD *

FROM

[$(QVDPath)C.qvd]

(qvd);

store [TableC] into [$(QVDPath)TableC.qvd] (qvd);

drop table [TableC];

[TableD]:

LOAD *

FROM

[$(QVDPath)D.qvd]

(qvd);

store [TableD] into [$(QVDPath)TableD.qvd] (qvd);

drop table [TableD];

ENDIF

Re: script meaning

jonathandienst — Tue, 18 Oct 2016 04:59:35 GMT

Are you asking what does the IF/ENDIF statement does? The script between these statements will only execute of the IF condition evaluates to true - in other words, if the variable vTable is set to to 'ALL' to 'TableA'

Re: script meaning

Tue, 18 Oct 2016 05:35:19 GMT

Yes Jonathan, My doubt is how to set these conditions? How to execute them? I am quite new for this concept. Could you please explain in details?

Re: script meaning

vcanale — Tue, 18 Oct 2016 10:14:46 GMT

Hi,
The Load of the tables [TableA], [TableB], [TableC]. [TableD] will happen only if vTable = 'ALL' OR vTable = 'TableA'

Re: script meaning

jyothish8807 — Tue, 18 Oct 2016 13:35:17 GMT

Hi Annio,

Over here vTable is a variable and it can have only one value at a time. A per your code,

If the variable “vTable” contains value either 'ALL' OR 'TableA' then it will meet the condition and load all the tables mentioned below.

Regards

Re: script meaning

wallerjc — Tue, 18 Oct 2016 14:48:12 GMT

If your variable "vTable" is set to "ALL" or "TableA" doesn't seem to matter here, it will still load TableA and TableB

You might need to show us more code to help you out further.

Thanks,

james.

Re: script meaning

rupamjyotidas — Tue, 18 Oct 2016 19:11:35 GMT

You need to find out where in your script the values of 'vTable' is set. Probably in your script or in Publisher