Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi team,
I am not getting any values in resident table
Kindly help its urgent.
Temp1:
Load * Inline
[ExpDetSetCdT,ExposureIDT,EXP
wer,123,234
edw,345,abc
edr,345,abc
wer,123,234
wer,123,234];
Exposure:
LOAD
ExpDetSetCdT as ExpDetSetCd,
ExposureIDT as ExposureID,
EXP as ExpIDT
Resident Temp1 where exists (ExpIDT,EXP);
Switch the order of fields within the Where Exists statement:
Exposure:
LOAD ExpDetSetCdT as ExpDetSetCd,
ExposureIDT as ExposureID,
EXP as ExpIDT
Resident Temp1
Where Exists (EXP, ExpIDT);
Update 1: In fact, this isn't right as well, I think Field is still called EXP, so all you need is just this:
Exposure:
LOAD ExpDetSetCdT as ExpDetSetCd,
ExposureIDT as ExposureID,
EXP as ExpIDT
Resident Temp1
Where Exists (EXP);
Update 2: Sample attached
Switch the order of fields within the Where Exists statement:
Exposure:
LOAD ExpDetSetCdT as ExpDetSetCd,
ExposureIDT as ExposureID,
EXP as ExpIDT
Resident Temp1
Where Exists (EXP, ExpIDT);
Update 1: In fact, this isn't right as well, I think Field is still called EXP, so all you need is just this:
Exposure:
LOAD ExpDetSetCdT as ExpDetSetCd,
ExposureIDT as ExposureID,
EXP as ExpIDT
Resident Temp1
Where Exists (EXP);
Update 2: Sample attached
EXPIDT field not found it shows.
Can you please elaborate it for understanding.
Thank you sunny but the check condition does not satisfy.All the data is loaded.
I just want to have the data whichexists condition satisfies.
Can Someone pls help me in understanding it
What is the output you are expecting to see my friend? Based on how this is structured (Resident from the table where you field name exits), you will see all the rows coming through. If you can provide the output, we might be able to help better
I just have sample of script..
Can you pls tell me the output of the below resident as am always getting the 0 rows inside it.
tempa:
LOAD
Description,
ID
FROM ...(table);
Tempb:
Load ID,
Description1
from ....(table);
ResidentA:
Load ID as ID_New
Description as Description_new
from tempa where exists(ID_New,ID);
Hi Kushal,
Request you not to create multiple post for the same question.
Your earlier post tricky exists thing has the answer in it. Kindly check.
Regards,
Kaushik Solanki
Sorry kaushik wont repeat that thing again.
Thank you for the reply in another post.