about sender and reciever structures

[Former Member]

hi friends ,

warm wishes......

i am having in source side three fields like name , city , pincode ....and at target side also the same fields are present ........but i want the text file from reciever system with only pincode+ cityname , without changing the reciever structures .

its very urgent...

thanks in advance.

[justin_santhanam]

Hello,

If you don't want to change the structure then follow the below steps.

Use concat function for City and pincode and map to anyone of the target structure field. I mean map to either name (or) city (or) pincode.

If you want the o/p file as CSV then do the content conversion.

Best regards,

raj.

[Former Member]

Raj,

<i><b>

If you want the o/p file as CSV then do the content conversion.</b></i>

If he does this then he will have an extra commas. I dont think this is what he is expecting.

---Satish

[justin_santhanam]

Satish,

Why comma is needed, for example the below format is not possible in CSV , let me know.

620019Trichy

560012Bangalore

607400Chennai

Best regards,

raj.

[Former Member]

JP,

I dont understand your requirement.

You source is having name , city , pincode.

In your target you need only pincode+ cityname. If you dont want name then it is not possible to create the file with this two fields pincode and cityname. You have to create a new structure for it. If you use the same structure then you will have problem in your receiver content conversion.

Is this what you are looking for?

---Satish

[Former Member]

hi,

actually i want only name , pincode+cityname in the reciever side .

if it is possible then how ?

thanks

jp.

[Former Member]

Hi jp,

in target structure, just specify two fields: name and pincode_city........then in mapping, map source name field to target name field........map pincode and city using concat function to target pincode_city field......then you will get your reciever file.......

Thanks,

Rajeev Gupta