Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Wild Card Match

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

3 Replies
MK_QSL
MVP
MVP

Use

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

nico_ilog
Partner - Creator II
Partner - Creator II

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?

robert_mika
Master III
Master III

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

This work:

This does not: