Macth 2 data in 2 tables

[pgalvezt]

Hello, I'm trying to emulate VlookupV (Excel) in QlikView with the WildMatch Function but doesn't work. I`ve attached a little qv with the 2 tables. The idea is looking in the A column and associate with the B Column and bring Fecha Protesto.

Thank you.

[#2 · Accepted solution]

If this is at QVW layer can you join columns A and B (with a same field name).

If this can be build into the data model we can use applymap function in the script.

Regards,

Kiran Rokkam.