Forum Discussion

adityamohanty's avatar
adityamohanty
New Contributor II
3 years ago
Solved

How to rename a column in a single expression without impacting the other columns in a json file

My source data looks like this. I want to rename "Emp.Type" column to "EmpType" in a single expression without impacting the other columns in json file. I don't want to use column map in mapper where...
  • Supratim's avatar
    Supratim
    5 years ago

    @Raph Just to validate, run your pipeline, once it’s completed check the no of document from output view of Soap execute snap from runtime log. If no of document count is 1 , which means you got a response from server, if any error comes either pipeline throw error or it will go to error view.

    You click on user setting whether auto validation is checked or not, to get the response during pipeline validation time.

patan's avatar
patan
New Contributor III
3 years ago

@AleksandarAngelevski Thank you for your feedback. but this solution will not work as I have more than 1000 records to be compared. A ternary operator solution might not fit my scenario.

Aleksandar_A's avatar
Aleksandar_A
Contributor III
3 years ago

@patan What you want to say is that the Comparator object will contain more documents than it has right now (2)?

  • acesario's avatar
    acesario
    Contributor II
    5 years ago

    Output meaning error?
    For this you need to add an error output to your soap execute (see screenshot below.

    Also helpful might be to see what you are writing or the response.
    Here is a link to the original conversation:Questions a soap execute Template - #10 by acesario

    I just ran into the same thing with seeing what I was sending to the soap execute. I was directed to use an xml generator, as shown here where i’m using a copy to send the input to both the soap execute and to the xml generator. The key here is copying your template to the edit xml input in the generator

    • Raph's avatar
      Raph
      New Contributor II
      5 years ago

      Output meaning it is a GET method. So after input of a person ID in the mapper snap there is no preview or output of the SOAP execute snap.

      I do not believe I need an XML generator to input one “string”. If I am mistaken please let me know.

      I believe our questions are not related.

      • acesario's avatar
        acesario
        Contributor II
        5 years ago

        @Raph Correct,you dont need the xml generator to submit… it is only to ‘see’ what you are sending in.

        Two ideas:

        1. Add an error output to the soap execute
        2. are you validating? Is the snap step setup for validate and execute?