wildmatch in where clause

[hopkinsc]

Hi all,

I have a table like the following..

Product	Period	Value
Item A	Cases201901	1000
Item B	Cases201902	1000
Item C	Vol201901	1000
Item D	Vol201902	1522
Item E	XX201901	4111
Item F	XX201902	2010
Item G	AA201901	3220
Item H	AA201902	4102

What i am trying to do is create separate tables for each of the period types (Cases, Vol, XX, AA).

so

Load

     Product,

     Period,

     Value

Resident ...

Where wildmatch(Period, 'Cases*');

does anyone have any ideas on how i can do this please? is wildmatch not the correct way?

[vamsee]

Hi Chris,

Your code looks right. What is the issue you are facing?

[hopkinsc]

Hi, its not actually working, i am still getting all periods, not just the ones starting with Cases..

[neelamsaroha157]

Not sure why its not working on your side. I just tried it and it works fine.

May be could be upper/lower case issue.

[vishsaggi]

OK you are doing a resident load here so are you doing a Left join to your upper table? Do an inner Join or show the full script you are trying to run.

[vamsee]

Try Using NoConcatenate If your taking a resident

A:

NoConcatenate

Load

     Product,

     Period,

     Value

Resident ...

Where wildmatch(Period, 'Cases*');

B:

NoConcatenate

Load

     Product,

     Period,

     Value

Resident ...

Where wildmatch(Period, 'Vol*');

[hopkinsc · Accepted solution]

Hi all, ignore me, I was having a blonde moment!

It is actually working, but it was being concatenated to the original table!

Thanks!

[hopkinsc]

Thanks yes, i have just noticed this and corrected.

[vishsaggi]

Can you close the thread marking correct/helpful responses please...

[vamsee]

Glad that it resolved your issue.

/*********************************************************************/

Please close the thread by marking the correct response also

https://community.qlik.com/docs/DOC-14806.