topic Re: Comparing a field value from Table1 to more than 1 value Table2 in QlikView

Comparing a field value from Table1 to more than 1 value Table2

mgavidia — Fri, 18 Sep 2015 22:28:13 GMT

Hello there!

I would like to know if there is an easier way to do this....

I take the field CallerNumber from the MonthlySourceData and compare it against 4 fields in the Customers table. If a match is found in any of the 4 fields, the value from InqLeaseNo in Customers table should be copied to the MonthlySourceData table.

I have managed to get the matching details by Applying Mapping tables on MonthlySourceData (ended up with 4 additional fields in MonthlySourceData); however, getting the InqLeaseNo seems to be a challenge...

Keep in mind that the only connection between these 2 tables is the CallerNumber that could be found on any of the 4 customers fields.

Any tips on working this out will be greatly appreciated.

Thanks,

Miguel Gavidia

Re: Comparing a field value from Table1 to more than 1 value Table2

Fri, 18 Sep 2015 23:48:37 GMT

Hi,

Have a look at the attached document and hope it helps!

Kiru

Re: Comparing a field value from Table1 to more than 1 value Table2

mgavidia — Sat, 19 Sep 2015 00:23:38 GMT

Hi,

I got my script to work but I jumped thru several steps..

Your process looks like will do the trick with a lot less steps; I'll give it a try and report the results...

Thank you very much!

Miguel Gavidia

Re: Comparing a field value from Table1 to more than 1 value Table2

Sat, 19 Sep 2015 02:26:00 GMT

Sure, No problem!

Re: Comparing a field value from Table1 to more than 1 value Table2

mgavidia — Mon, 21 Sep 2015 18:26:28 GMT

Kiru,

I applied your process to my script and it worked flawlessly!

Thanks again for your help.

Miguel Gavidia

Re: Comparing a field value from Table1 to more than 1 value Table2

Mon, 21 Sep 2015 18:34:32 GMT

No problem, I am glad you got the desired result!