How to match two fields with almost the same content

[#1]

Hi all!

I have the following problem: I have one field showing a code and another field showing the same code with some more digits at the end or at the beginning of the field. I have to match and select the two fields independently by the more digits, for example:

field 1:  mdfgxx2011

field 2: mdfgxx2011-32_def

or

field 2: IT_mdfgxx2011

Thanks!

Francesco

[jvitantonio]

Hi Francesco,

You can use the left() and right() Qlik functions, but this will work only if you know what records have a prefix and which records have a sufix. 

[Anonymous]

Ciao Francesco,

you can also try the funcione LIKE :    like '*mdfgxx2011*'

[jvitantonio]

Like will not work in this case as he needs to join the table. Like is used in a where clause

[#5]

That's correct....I should have a column with all the values contained both in field 1 and 2 .....like dosn't allow me to match teh entire column values...