topic Re: Resident load with exists not working in QlikView

Resident load with exists not working

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Resident load with exists not working

sunny_talwar — Wed, 17 Aug 2016 08:22:35 GMT

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

Re: Resident load with exists not working

Anonymous — Wed, 17 Aug 2016 09:56:36 GMT

EXPIDT field not found it shows.

Can you please elaborate it for understanding.

Re: Resident load with exists not working

Anonymous — Wed, 17 Aug 2016 10:50:00 GMT

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.

Re: Resident load with exists not working

Anonymous — Wed, 17 Aug 2016 13:22:43 GMT

Can Someone pls help me in understanding it

Re: Resident load with exists not working

sunny_talwar — Wed, 17 Aug 2016 21:32:22 GMT

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

Re: Resident load with exists not working

Anonymous — Wed, 17 Aug 2016 23:03:32 GMT

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,

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

Re: Resident load with exists not working

kaushiknsolanki — Thu, 18 Aug 2016 05:54:27 GMT

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

Re: Resident load with exists not working

Anonymous — Thu, 18 Aug 2016 12:54:36 GMT

Sorry kaushik wont repeat that thing again.

Thank you for the reply in another post.