doubt in case

[Anonymous]

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

[vinieme12]

what is the doubt , can you explain in brief

[vinieme12]

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

[vinieme12]

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;

[Anonymous]

i did it but it shows me error..

[vinieme12]

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;

[vinieme12]

if your query is resolved, please close the thread

[Anonymous]

Thanks Vineeth now it is working