Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi all, ignore me, I was having a blonde moment!
It is actually working, but it was being concatenated to the original table!
Thanks!
Hi Chris,
Your code looks right. What is the issue you are facing?
Hi, its not actually working, i am still getting all periods, not just the ones starting with Cases..
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.
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.
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*');
Hi all, ignore me, I was having a blonde moment!
It is actually working, but it was being concatenated to the original table!
Thanks!
Thanks yes, i have just noticed this and corrected.
Can you close the thread marking correct/helpful responses please...
Glad that it resolved your issue.
/*********************************************************************/
Please close the thread by marking the correct response also