topic Finding a match between subfields of two strings in QlikView

Finding a match between subfields of two strings

Tue, 18 Jun 2013 21:08:18 GMT

Is there an expression that can find matches between substrings of two fields that both have comma delimitted substrings?

Field_1 = 'USA', 'Italy', 'Japan'

Field_2 = 'Jamaica', 'Italy', 'Australia', 'Korea', 'China', 'Chile', 'Mexico'

Is there an expression I can use in a text object or a chart, to tell that Field1 and Field 2 do have a match WITHOUT using the load script?

In the example above, both fields have 'Italy'. The expression would help to determine that both Field_1 and Field_2 contain 'Italy'.

Re: Finding a match between subfields of two strings

tresB — Wed, 19 Jun 2013 04:27:05 GMT

Ideally, you should use subfield function during LOAD to generate one full record of input data for each substring. Once done, you can easily compare the vaules from different fields.

Thanks.

Re: Finding a match between subfields of two strings

Wed, 19 Jun 2013 05:14:36 GMT

Use the InterRecord function lookup...

Re: Finding a match between subfields of two strings

Wed, 19 Jun 2013 05:33:37 GMT

see attachement