Resident load with exists not working

[Anonymous]

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);

[sunny_talwar · Accepted solution]

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

[Anonymous]

EXPIDT field not found it shows.

Can you please elaborate it for understanding.

[Anonymous]

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.

[Anonymous]

Can Someone pls help me in understanding it

[sunny_talwar]

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

[Anonymous]

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);

[kaushiknsolanki]

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

[Anonymous]

Sorry kaushik wont repeat that thing again.

Thank you for the reply in another post.