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: 
Anonymous
Not applicable

doubt in case

A:

Load * Inline

Name, Acode, Cost

a, P, 2

b, Q, 4

c, R, 5

d, S, 6

];

Left Join(A)

B:

Load * Inline [

Name, Place

a, x

c, y

];

NoConcatenate

C:

Load Acode

if(Place = 'x', 2,1) as Birth

Resident A;

Endif

7 Replies
vinieme12
Champion III
Champion III

what is the doubt , can you explain in brief

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

You don't need endif in the load statement

in the load statement IF() is used like a function

IF( condition, then , else)

when writing blocks of script , you will write as

IF    condition   THEN

<<scriptcode>>

ELSEIF

<<scriptcode>>

ELSE

<<scriptcode>>

END IF

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

So your script should be

A:

Load * Inline

Name, Acode, Cost

a, P, 2

b, Q, 4

c, R, 5

d, S, 6

];

Left Join(A)

B:

Load * Inline [

Name, Place

a, x

c, y

];

NoConcatenate

C:

Load Acode

if(Place = 'x', 2,1) as Birth

Resident A;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

i did it but it shows me error..

error.PNGerror2.PNG

vinieme12
Champion III
Champion III

there should be space between inline and [

A:

Load * Inline [

Name, Acode, Cost

a, P, 2

b, Q, 4

c, R, 5

d, S, 6

];

Left Join(A)

B:

Load * Inline [

Name, Place

a, x

c, y

];

NoConcatenate

C:

Load Acode,

if(Place = 'x', 2,1) as Birth

Resident A;

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

if your query is resolved, please close the thread

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Anonymous
Not applicable
Author

Thanks Vineeth now it is working