Forum Discussion

clarrivey's avatar
clarrivey
New Contributor
4 years ago

Using union in Execute SQL snap

I have an Execute SQL where I wan to add column names to my output file before adding the data. For example: select ‘Last_Name’||chr(09)||‘First_Name’ from sys.dual union select rtrim(spriden_l...
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
3 years ago
Copy LinkReport

@Igor_Bozhinovski

The simplest way to do the routing is by splitting the array using the JSON Splitter Snap, and then in the Router Snap add the logic where you will route the records based on the “test” field(if it is empty or not).

BR,
Spiro Taleski

  • pradeepkumar's avatar
    pradeepkumar
    New Contributor II
    3 years ago
    Copy LinkReport

    Can you tell what are you using to route in Binary router snap Please

    • pradeepkumar's avatar
      pradeepkumar
      New Contributor II
      3 years ago
      Copy LinkReport

      Hi @svedantam

      I hope these works you just need to add one more output view to the binary router in your pipeline and use for error and also toggle first match and see the output.

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    3 years ago
    Copy LinkReport

    Hi @svedantam,

    As per the error message, you need to have a snap before “Binary Router” snap as it is looking for a source data, if I may ask, did this pipeline run before you attempted to create an ultra task?

    Source systems could be anything ranging from a flat file, snowflake, oracle, salesforce, etc.
    Thank you.

    Regards,
    Darsh