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
Here is a sample pipeline to show what I am trying to describe. This is using a SQL Server Execute snap - I don’t believe you specified which database you are using.
Community Post 12674_2022_06_10.slp (5.3 KB)
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
