Matching part of a string of text

[Anonymous]

Hi

I have product code numbers and product descriptions in a table in Qlikview.  In an excel spreadsheet somebody inputs the product code from a debit note issued by a customer.  The reliability of the product number on the debit note is not good and there is often either the first number, last number or both missing.  I want to look up the number input onto the spreadsheet with the product code numbers in qlikview to return the product description.  I need the numbers to match as in the table below

ProdNo	DebitNoteProd
01830910	01830910
01377301	0137730
01617798	1617798
01546764	154676

Is the wildmatch function the right solution?

Thanks

A

[#2]

Hi Adrian.

Yes wildmatch would work best for you here just make sure to include the * at the start and end of your input

Joe

[Gysbert_Wassenaar]

Perhaps you're looking for the Mapping with Wildcards recipe from Recipes | Qlikview Cookbook

[sasiparupudi1]

Yes It should work fine

if (WildMatch(01377301    ,'*0137730*'),'True','False')

[antoniotiman]

Use

=If(SubStringCount(ProdNo,DebitNoteProd)  > 0,...

in Script or Front End

[jonathandienst]

None of these conditions will match for missing digits in the middle of the field...

[sasiparupudi1]

Hi

You will get false matches if your strings are in a sequence

DebitNoteProd ='*0137730*'

ProdNo

'01377301'

'01377302'

'01377303'

HTH

Sasi

[Anonymous]

This looks promising except that it seems to work the other way round. In your example the part-codes have the description attached but I have the full codes with descriptions and I want to find part-codes in that list and give it a description.

Confused

A

[sasiparupudi1]

As said before, you will not get correct answers using substringcount or wildmatcch in your scenario