topic Re: Wild Card Match in QlikView

Wild Card Match

Thu, 19 Mar 2015 20:15:03 GMT

Hello:

I have a table that have GL accounts like 62000, 62001, 62002.... and so on, and I have another table in excel where an user should be able to assign departments based on the GL accounts, but they should be able to do this using wild card search like if it is GL Account 620?? then assign it to "Sales"

If there a way where two tables can be joined by fields, if the field in one of the table contains wild cards like in example above, appreciate any suggestions / input

thanks

Re: Wild Card Match

MK_QSL — Thu, 19 Mar 2015 20:20:53 GMT

Use

WildMatch([GL Account], '620*') as AccountType

Re: Wild Card Match

nico_ilog — Thu, 19 Mar 2015 23:01:51 GMT

Hi Kumar,

You could also just say Left([GL Account],4) as Account Type.

You can the re-use the Left function in your excel sheet as well?

What are you looking for as the end result?

Re: Wild Card Match

robert_mika — Thu, 19 Mar 2015 23:22:56 GMT

If you need to match only two charakters after 62 you can use

This work:

This does not: