on 02-06-2016 4:18 PM
Hello experts,
I have an incoming structure like this:
the target structure is:
Where (number of ITEM) = (number of SPLIT) X (number of LINEITEM)
EMAIL = SPLIT[Owner]
PARTN_ROLE = Index of SPLIT
ITM_NUMBER = LINEITEM[LineNumber]
How do I do this using graphical mapping and/or UDFs?
Any help is appreciated.
Thanks!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kiryl ,
Graphical mapping should do.
1.(number of ITEM) = (number of SPLIT) X (number of LINEITEM)
EMAIL = SPLIT[Owner]
Select statistic function count and arithmetic function multiply. You can use removecontexts if the splits are coming in different contexts.
ITem = Count[SPLIT} Multiply Count[LINEITEM]
2.EMAIL = SPLIT[Owner]
you can do a direct mapping here.
3.PARTN_ROLE = Index of SPLIT
Try index of function in TEXT. When you say index of split any character index in split?
4.ITM_NUMBER = LINEITEM[LineNumber]
you can do a direct mapping here.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.