SQL Query Node - dropping columns

laura-patenaude

Hi - I'm running a fairly simple SQL query in the SQL query node in my flow.  However, the results are coming back with column headings and I do not want them in my results - the file is going to another system which is expecting them not to be there.  Is there a simple way to drop the column headings initial record in the CSV file?  I have the box checked, in the SQL query node, to generate a CSV file from the resultset.  We are on V10 on premise.   Thanks in advance, Laura

0911060553270289.pdf

russel-cornelson

The SQL Node doesn't have a way to do it automatically so if I were you I would do something like the following in an assign node javascript

ASSIGN NODE JavaScript after the SQL Query
var resultSet = String(SQLID_CSV).split(/
|
|
/).filter(Boolean)
resultset.shift()


From there you could do something like 

FileAccessNode - write to file where the following is the input data
<!resultSet.join("
")>

Or just assign the data back into the SQLID_CSV variable using javascript
SQLID_CSV = resultSet.join("
")



EXPLANATIONS
String(fieldname) ... ensures that the field is treated as string
.split(/
|

/)  ...  will split the file into lines on either
(windows) 
(linux/unix) or
(mac)
.filter(Boolean)  ... uses a truthy to eliminate any blank lines from the results

<!resultSet.join("
")>  I think this throws an error when you click ok but at runtime it does work.  it performs the join on the array at execution so you dont have to save it off to a string first when writing it out.

resultSet.join("
") ... this joins an array back into a string;  it inserts
between each element.