UDF

[praveenreddy_bk]

Hi ,

Can b done is Graphical Mapping or UDF

YYYYMMDD41NNNN

Where:

YYYYMMDD is converted from the source value YYMMDD and NNNN is the 4 digit incremental number given in PI for all records which starts from 000001 (+1) to the last records in the source file.

Here YYYYMMDD is current Date

Thanks in Advance

[madanmohan_agrawal · Accepted solution]

Hi Praveen,

Yes, It can be done by Graphical Mapping.

First use standard function "CurrecntDate" to find current date

then use standard function "INDEX" to increase the number everytime the record is found

Finally use standard function "concat" as below

"CurrecntDate" concat constant "41" concat "INDEX".

Regards,

Madan Agrawal

Edited by: Madan Agrawal on Apr 15, 2009 12:24 PM

[former_member200962 · Accepted solution]

how can CUrrentDate help here if the value is coming from SOurce file??

[former_member200962]

Hi,

Can be done without UDF..

YYYYMMDD is converted from the source value YYMMDD

use Concat function to have YYMMDD --> just make sure with what century you want to start like should it be 1984 or 2084....

NNNN is the 4 digit incremental number given in PI for all records which starts from 000001 (+1) to the last records in the source file.

to achieve this use the Index function present under the Static functions group....do not use a counter it may cause problem for multiple records....personal experience here:)

Regards,

Abhishek.

[former_member181962]

Can you explain more clearly?

What id 41 in YYYYMMDD41NNNN? Constant?

Regards,

Ravi Kanth Talagana