1.2k questions

1.4k answers

361 comments

339 users

Categories

Sidebar
0 votes
608 views
by mike-h-4810 (180 points)
What is the syntax for the Insert INTO command on a database destination node?  Example:

Insert into Table-Name

(Column1, Column2, Column3)

Values (message.getNode('1'),message.getNode('2'),message.getNode('3'))

What's the syntax to link the corresponding getNode to the  column Values?

1 Answer

0 votes

The syntax for a CSV would be like the following

Insert into Table-Name
(Column1, Column2, Column3)
Values ({m:1},{m:2},{m:3})

The {m:1} tag points to the 1st column in the csv of the message. Please refer to the reference guide in the help menu for a full list of nodeTags.

by brandon-w-8204 (34.1k points)
...