topic Re: Load data based on if...else condition in QlikView

Load data based on if...else condition

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

Hi All,

Want to load data based on below condition:

Suppose I have two computers 'A' and 'B' then my load condition should be,

if(ComputerName() = 'A')

Load

A.Data as DataA

From xyz path;

if(ComputerName() = 'B')

Load

B.Data as DataB

From xyz path;

Please help me to write this code in QlikView script editor??

Re: Load data based on if...else condition

sunny_talwar — Thu, 05 May 2016 10:45:35 GMT

May be like this:

IF ComputerName() = 'A' then

FirstLoadHere

ELSEIF ComputerName() = 'B' then

SecondLoadHere

ENDIF;

Re: Load data based on if...else condition

marcus_sommer — Thu, 05 May 2016 10:46:46 GMT

Try this:

if ComputerName() = 'A' then

Load A.Data as DataA From xyz path;

else

Load B.Data as DataB From xyz path;

end if

- Marcus

Re: Load data based on if...else condition

soha1902 — Thu, 05 May 2016 11:04:57 GMT

Hi Sunny and Marcus,

Can you please let me what is wrong in this code? why it is showing red line? Please see attached image.

if ComputerName() = 'ATHENA-BLD-02-P' then

Load

[(PDH-CSV 4.0) (Central Daylight Time)(300)] as Time_Interval

FROM

[$(vDataFile)CPU_RAM_Usage.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

elseif ComputerName() = 'B' then

Load

[(PDH-CSV 4.0) (Eastern Daylight Time)(300)] as Time_Interval

FROM

[$(vDataFile)CPU_RAM_Usage.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

endif;

Re: Load data based on if...else condition

marcus_sommer — Thu, 05 May 2016 11:09:06 GMT

There is a semi-colon missing after the file-format statement.

- Marcus

Re: Load data based on if...else condition

sunny_talwar — Thu, 05 May 2016 11:15:55 GMT

Yes you are missing a semi-color at the end

IF ComputerName() = 'ATHENA-BLD-02-P' then

TableName:

Load

[(PDH-CSV 4.0) (Central Daylight Time)(300)] as Time_Interval

FROM

[$(vDataFile)CPU_RAM_Usage.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

ELSEIF ComputerName() = 'B' then

TableName:

Load

[(PDH-CSV 4.0) (Eastern Daylight Time)(300)] as Time_Interval

FROM

[$(vDataFile)CPU_RAM_Usage.csv]

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

ENDIF;

Re: Load data based on if...else condition

Kushal_Chawda — Thu, 05 May 2016 12:24:16 GMT

Instead of doing this in script why don't you just do conditional on front end.

Lets say you add two dimension

1) [(PDH-CSV 4.0) (Central Daylight Time)(300)]

Check enable conditional - if(Computername()='A',1,0)

2) [(PDH-CSV 4.0) (Eastern Daylight Time)(300)]

Check enable conditional - if(Computername()='B',1,0)

Re: Load data based on if...else condition

santiago_respane — Thu, 05 May 2016 12:54:16 GMT

I don't think you can solve that with the computerName() function, it will never return more than computer name per execution, unless you change your .qvw from one computer to another in the middle of the execution.

Do you have one application per computer?

Kind regards,