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...
Forum Discussion
@clarrivey - perhaps I’m missing the goal you are trying to achieve here. From your original post, it appears that you are trying to create a header record for your output with the data coming from the second query. If you are trying to write those results to a tab-delimited file, then the example I provided will work - just copy the query from the SQL Server Execute snap in my example to an Oracle Execute snap. This works because SnapLogic’s CSV Formatter can use the field names of the input document as the header record in your file, which is how I configured the example pipeline. Also notice that the CSV Formatter snap is setup to use the tab character (\t or \u009) as the Delimiter.
