Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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
MVP
MVP

Use

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

Partner
Partner

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?

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

This work:

This does not: