Can Iterations be done for Wildmatch funciton?

[#1]

Hello all,

I have the following problem in my script. I have two tables

Table 1:

Key	Name
100	‘PjtXYZ #NLPOAC, Tra #NLPSHX'

Table 2:

Key	Partner
100	HP
100	SAP
100	Microsoft

Now my second table (partner) should look like the below

Key	Partner	NLP	JSO
100	HP	#NLPOAC	HP Kit
100	SAP	#NLPSHX	SAP Run
100	Microsoft

In table 1, under 'Name' field, I have 2 '#NLP strings'. I want to identify both strings one after another.

Is there any iterative function available in qlikview for wildmatch functions so that strings are searched one after another.

Each string should have one partner.

Kindly help me on this.

Thanks in advance,

Vidhya

[tresesco]

There would be some work around. Could you explain - how you associate #NPLOAC with HP and #NLPSHX with SAP? Is it the order?

[#3]

Thanks for your quick repli!!

There is no specific order. In table 2, first partner is 'HP'. So the first '#NL' string should be tagged to HP.

At the end I should have #NL string for all the partners available.

We have 3 Keys with different Partners.

So, each Partner should get #NL string.

Hope this helps.

[tresesco · Accepted solution]

May be like attached qvw?

[#5]

thanks, this is what I wanted.

i tried to do the same in the attached qvw file, I dont get  the exact result.

Could you please advise where I have gone wrong?

Thanks in advance

Vidhya

[tresesco]

Change the SubField separator from comma to semi-colon ':' and try like:

SubField(Name, ':') as Name

[#7]

Hi Deepak,

Sample application is attached here.

Kindly help me on this.

Thanks,

Vidhya

[#8]

Hello Tresesco,

I still get the same.

Kindly have a look at the attached screenshot.

Thanks,

Vidhya

[#9]

Is there any While statement wherein we can use IterNo() to achieve the result.

Like

Load
Key,

if(<There is an IterNo() occurrence of *#NL?B* in the Name>,

<Distill this IterNo()’s occurrence from the Opty Name>) as NLPB
Resident Table1;

While <there are more occurrences of *#NL?B* in the Name>;

Thanks,

Vidhya

[tresesco]

Try to share your sample data excel.