topic Re: Matching multiple fields in one table with other table in QlikView

Matching multiple fields in one table with other table

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

I have a situation where I need to compare multiple fields with one field and than have it say as matched or not-matched if it either matches or not matches

Details:

Table1

Field1 - 10.1.1.100

Field 2- 10.2.2.101

Field3 - 10.3.3.103

Table 2: FieldA has data separated by Comma (,)

FiledA: 10.1.1.100, 10.1.1.101, 10.1.1.103

So, when I compare all the above four fields from Table1 with FieldA in Table 2, since there is a match (10.1.1.100) this has to be labelled as “Matched” if there is no match it should display as “No Match”

Re: Matching multiple fields in one table with other table

JGMDataAnalysis — Sat, 02 Nov 2019 16:11:24 GMT

Something like this?

Table1: NOCONCATENATE LOAD * INLINE [ Field1, Field2, Field3 10.1.1.100, 10.2.2.101, 10.3.3.103 ]; Table2: NOCONCATENATE LOAD Trim(SubField(FieldA, ',')), 'Match' ; LOAD * INLINE " FieldA 10.1.1.100, 10.1.1.101, 10.1.1.103 " (delimiter is ';'); MapFieldValues2Match: MAPPING LOAD * RESIDENT Table2; Final: NOCONCATENATE LOAD *, ApplyMap('MapFieldValues2Match', Field1, ApplyMap('MapFieldValues2Match', Field2, ApplyMap('MapFieldValues2Match', Field3, 'No Match'))) AS Test RESIDENT Table1; DROP TABLES Table1, Table2;

Re: Matching multiple fields in one table with other table

Brett_Bleess — Thu, 07 Nov 2019 20:29:12 GMT

Remo, did Javier's post help you get things working as you wanted? If so, do not forget to return to the thread and use the Accept as Solution button on the post to give him credit for the help and confirm to others that it did solve your problem. If you still need further help, leave an update on things.

Regards,
Brett