Skip to Content
avatar image
Former Member

about sender and reciever structures

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jun 04, 2007 at 04:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • Jun 04, 2007 at 04:55 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded