Converting SQLite Query to a CSV File

#1

Hello!

Quick question, I'm hoping you folks can help me out with. I've created an SQLite database to store time-based data about my system and want to create and export a .csv file of specific queries on demand.

So far I'm able to create a query, send the returned database results in a message, and convert to a CSV, and create a file; however, it looks like only a portion of the data is being transmitted.

There are 14 columns of data I expect to be exported, but only 5 are visible in the .csv file. See screenshots for output.


#2

How is the csv node configured ?

#3

CSV node configured as shown.

#4

Your template line says things like bin50 which doesn’t match the debug that shows things like b50

#5

That was it. Thank you! It works like a charm now.