on 12-12-2011 3:23 PM
Hello every one i have recently joined a product based company as a PI developer,
I have got a small mapping issue my requirement is like given below my target feild PARTNERID should be mapped to 7TW7006 if source feild: SITE value is FRE and should be mapped to 7TW7005 if source field SITE:value is WC and should be mapped to 7TW7008 if source feild SITE:value is WC2
What i mean is source feild is SITE and Target feild is PRTNERID
PARTNERID value should be 7TW7006 when SITE feild value is FRE and vice versa with WC and WC2
Any help is appriciatable since iam new to mapping
hi,
I don't see where is your issue, it's a simple rule based on IF...ELSEIF.
You can acheive it either by using three IF or by using only one FixValue like that:
Graph: SITE --> FixValue --> PRTNERID
SITE (value) --> PRTNERID (value)
FRE --> 7TW7006
WC --> 7TW7007
WC2 --> 7TW7008
regards.
Micakel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Micakel,
Thanks very much for your help, actuall that was very simple sorry i am really new to PI, I belong to EDI actually.
I have got another small doubt,
Actually the above requirement i have mention was supposed to be CSV file look up i mean, mapping requirement is like this Lookup Column A on 'Cross-Ref' tab and Map Vendor Code
The below shown one is Cross-Ref' tab since there were only 3 possible occuring values in colum A (FRE, WC and WC2) fileds in column A and i found that going for CSV look up will be time taking process,
Site Vendor Code
FRE 7TW7006
WC 7TW7005
WC2 7TW7008
I just wanted to know if my approach is right or should i definetly go for Lookup.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
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.