Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am searching for a term like *. That means every caracteristic is possible. My case:
I have a key which consists of several fields in my load statment:
Account1&'-'&Account2&'-'&Account3 as KEY
Now I want to define several Accounts as KPIs ( if Acconut1='1200' and if Account3'x' as KPI='Orders')
KPI_match:
Load * Inline [
KEY, KPI
1200- *-x, Orders
];
But * does not work. How can I generate a key with placeholders in order not to write down every parameter (like: 1200-1-x; 1200-2-x) because Account2 is changing every period. But for some other KPIs I need Account2, so it has to be part of the key.
table (no KPI definitions included): | |||
Account1 | Acconut2 | Acconut3 | value |
1200 | 1 | x | 20 |
1200 | 2 | x | 20 |
1200 | 2 | 5 |
Perhaps WildMatch(Key,'1200*x')?
You could also just look at each of the three fields individually instead of at the concatenated key.
where can I put the wildmatch statement? As a new table?
If I take each field indivually I am generating syn keys because every KPI refers to an other Account
If you're looking to achieve this in the context of creating generic keys within your script, have a look at this document (sorry, it's a bit on the long side, but you probably won't need the entire thing):