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...
Aleksandar_A's avatar
Aleksandar_A
Contributor III
2 years ago

Hello rpc1235x,

You can produce the query string in the Datetime Fixer Mapper, and pass it as is to the Snowflake Execute Snap with Pass Through enabled.

That way you will have the query string in the original attribute downstream.

 

Regards,

Aleksandar.

rpc1235x's avatar
rpc1235x
New Contributor II
2 years ago

Thank you! I ended up using this solution.

If it helps others, here is how it looks:

 

Inside mapper 2, included:

  • $date_1
  • $date_2
  • the query
  • Date.now() for tracking purposes

 

  • dmiller's avatar
    dmiller
    Former Employee
    4 years ago

    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

    @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.