Forum Discussion

Akhil's avatar
Akhil
New Contributor
4 years ago

How to remove Escape character while file writing CSV formatter

I am trying to write a file with custom header separated by semi-colon (reading header from expression library as string)followed by data. While writing using CSV formatter escape character ‘\’ i...
pavia's avatar
pavia
New Contributor II
2 years ago
Copy LinkReport

I'm not clear how a Join would work here for a lookup. Along with other transformation taking place, I want to look up the values and pass them into different fields based on finding the matched code so I am envisioning it happening in a mapper snap.

So my original file could have Name and the CovCode, but the result file might have Name, some other hardcoded fields, Plan, and Tier.

  • dmiller's avatar
    dmiller
    Former Employee
    4 years ago
    Copy LinkReport

    Hi @Richard,

    We may need a bit more information of how your pipeline is configured. Is the message coming directly into a RabbitMQ Consumer Snap or do you have something before it?

  • Supratim's avatar
    Supratim
    Contributor III
    4 years ago
    Copy LinkReport

    @Richard If I understand your question correctly, you can refer below steps-

    1. Open Rabbit MQ consumer snap and go to view tab . Select error view option
    2. Add mapper for custom error message and then right click on mapper. Then select Link output to Error Pipeline. It should pass your custom message to error pipeline.

    Hope it might help you.