Issue with Target File structure

[Former Member]

Hi Experts ,

Mine is a proxy to file scenerio. please suggest me on the below req. My target file structure should be as follows.

HDR:PARTNER,CHDAT,NEW_TEL,OLD_TEL,PREF_CONTACT_NO,TEL,EXXX_ID

1029382,28.02.2011,0782191829,049829329,Y,3,0

1029382,28.02.2011,0783484311,077383738,N,2,0

1029382,28.02.2011,01972383934,0113938393,N,,0

1039385,28.02.2011,0782133829,079829310,Y,3,0

10245748,28.02.2011,N,,,,DAVID.WHITAKERattheYAHOO.CO.UK

112928393,28.02.2011,01183393843,01123839388,N,,Tom.HanksattherateSKYdotCOM

FTR:UPDATE_VENDOR_CONTACTS_SRM_TO_EIS,01.03.2011 02.18.29,6

This structure has 3 parts , header , body and trailer.

I am planning to create a target structure . Is it possible to get the field names of the structure in it

Header

HeaderInfo : HDR:PARTNER,CHDAT,NEW_TEL,OLD_TEL,PREF_CONTACT_NO,TEL,EMAIL_ID

Body

1029382,28.02.2011,0782191829,049829329,Y,3,0

1029382,28.02.2011,0783484311,077383738,N,2,0

1029382,28.02.2011,01972383934,0113938393,N,,0

Footer

Footer Info :FTR:UPDATE_VENDOR_CONTACTS_SRM_TO_EIS,01.03.2011 02.18.29,6

I will take care of the comma and the single line for header/footer and multiline for body in content conversion ,

In the footer I need date and time stamp along with total number of rows for the body.

How do I get the same .

Please suggest .

Arnab.

[baskar_gopalakrishnan2 · Accepted solution]

>>In the footer I need date and time stamp along with total number of rows for the body.

To get date and timestamp ,

currentDate -> DateTrans ->Footer field 1.

DateTrans specify both date and time format with seperator for input date and output date format

To get total number of rows for the body

body -> count -> Footer field 2.

Concating all : provide values 1 and 2 as input to concat field and map it to Footer field

[Former Member]

Hi,

Yes you can get the timestamp and count of no of records in the footer.

Please define your target structure like below

MT_

Records

Header ( o to 1)

Headerdata

Items(0 to unbounded)

field1

fielld2

....

Footer

Footerdata

And in the mapping get the current dat using data function.

And then pass the Item node to the function count

Concat both of them along with the constants you need and assign to footer data..

Thanks

Suma