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...
clarrivey's avatar
clarrivey
New Contributor
4 years ago
Copy LinkReport

Hi Rory,

I’m using Oracle, but I could not get it to work because it is basically creating a single record in the second query.

Chris

    • aanchalrajpal's avatar
      aanchalrajpal
      New Contributor
      8 years ago
      Copy Link

      Hi,

      Thanks for providing the solution, the pipeline solves the concern of splitting a record of csv however my csv also has a single line record and the pipeline shared by you its giving error when trying to execute with that file.I have attached source file, kindly help in getting it resolved.

      sample.txt (155 Bytes)

      Error:
      Failure: Error parsing at line 2, Reason: Cannot complete CSV data parsing, Resolution: Please provide valid CSV data at line 1 or route it to the error view

      • aanchalrajpal's avatar
        aanchalrajpal
        New Contributor
        8 years ago
        Copy Link

        Hi,

        Can anyone help on it , I need it badly to solve my pending issue.