Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
what is the doubt , can you explain in brief
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
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;
i did it but it shows me error..
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;
if your query is resolved, please close the thread
Thanks Vineeth now it is working