pi MAPPING

[Former Member]

Hello every one, i work on EDI and in our organization we are started using PI recently, i have been trained on it but never really worked on it, now i am building a interface but got stuck at mapping

my requirement is Concatenate date and serial number in CCYYMMDD format with Serial Number

Can any one please help me with this

[Former Member · Accepted solution]

Hi,

If date is not coming in YYMMDD format then you have to first use DateTrans fucntion

Serial number

                                                    ----> Concat  -----------> Output

EDI Date ----> DateTran (Fucntion) ---> YYMMDD

• You can search in SDN for more help for this sort.

regards

Ramesh

[Former Member · Accepted solution]

Sorry about the confusion but CCYYMMDD is the date and should be concacnated withs serial number, example if the date is

2011-11-12 and serial number is 789

Then resultant should be 20111112789 i mean date should come first in concatination.

CCYYMMDD format might have confused you its actually century year month day format

[Former Member · Accepted solution]

Ok,

Then,

EDIDate ---> DateTrans (Standar Fucntion) --->

                                      -------------->> Concat -----> Desired Output.

Serial Number ---> 

Here,

You have to use DateTrans function to convert 2011-11-12 to 2011112

Regards

Ramesh

[Former Member · Accepted solution]

Thanks Ramesh for your help

It would be great if you can help me with one more map

The requirement is i should map year Based on System date, i mean there is year feild in target side it should always show current year.

[Former Member · Accepted solution]

Ofcourse, you can make use of standard date fucntion

currentDate

which will return you the current date.

So make use of it to achieve your desired output.

Change the target format of currentDate function to yyyy (lower case) to get only year

Regards

Ramesh

[Former Member · Accepted solution]

Thanks Ramesh there is small problem in it

I have got five different feilds like given below all the feilds want there current respectives, i mean year should be current year, month should be current month. how is it possible with current date function

YEAR

MONTH

DAY

HOUR

MINUTE

[Former Member · Accepted solution]

Here how you can achieve

CurrentDate (standard function) select its target format as yyyy (small case)  YEAR

CurrentDate (standard function) select its target format as MM (upper case)  MONTH

CurrentDate (standard function) select its target format as dd (small case) DAY

CurrentDate (standard function) select its target format as HH (upper case) HOUR

CurrentDate (standard function) select its target format as mm (small case) MINUTE

[Former Member · Accepted solution]

Thanks very much Ramesh, that was great.

[Former Member]

Hi chandrika,

Assuming

1. your serial number is coming as CC

2. Date is coming as YYMMDD

Then

CC
                          ---> Concat Function ---> Target Node
YYMMDD

Regards

Ramesh