cancel
Showing results for 
Search instead for 
Did you mean: 

Message mapping help

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Deepthi,

Since you are having only 3 possible values using Fixvalues option is best suited for your requirement.

Lookup is best suited when your Cross-Ref table is keep adding new values very frequently. Since your Cross-Ref table has only 3 possible values Fixvalues is best

Regards

Ramesh

Answers (0)