IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Generating a .csv file

    Posted Wed July 05, 2017 10:51 AM

    In order to generate a csv output like below, what should be the field position and delimiter?
    Record1 Record2 Record3
    Field 1 Field2 Field3

    Record position - 0, delimiter comma
    Field position - 9(counting Record1 position), delimiter comma

    My output now:
    Record1Field1 Record2 Field2 Record3 Field3

    Always the field comes in the same line as Record but I need the field value below the corresponding record on the next line. What is the way to do this?


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services


  • 2.  RE: Generating a .csv file

    Posted Wed July 05, 2017 03:26 PM

    Hi Venkat,

    can you define the line with the Records as a Header line?

    can you provide some screen shots from your schema and dictionary definition?

    Regards,
    Holger


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


  • 3.  RE: Generating a .csv file

    Posted Thu July 06, 2017 02:24 AM

    Hi Holger,
    I didn’t create a dictionary, using schema directly for now. Delimiters and field, record positions mentioned in my previous post. Keeping the records as header is exactly what I’m looking for.


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


  • 4.  RE: Generating a .csv file

    Posted Fri July 07, 2017 03:59 AM

    I managed to create the CSV by making 2 dicts & 2 schemas, one for records as header and other for corresponding fields.


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services