MySQL to SQL Server

[Jonathan]

{{ $json.firstname + " " + $json.lastname }}

This one work ! The first one didn’t Thanks !

[Jonathan]

One more question

As you can see here, in my Merge input I have name_1 and name_2, yet they are not working in the query. I have no error, but get an “undefined” in the column.

Also, it seems that it is possible to get items from an input by doing, for example, $(‘MySQL4’) to get items from the MySQL4 node, is it correct ? If I need only one item from a node, maybe that’s a better way to do it than a merge ?

Thanks!

[Jon]

Hey @Jonathan,

Is it also red if you use {{ $json["name_2"] }}? You are correct on the other part you can reference another nodes json data with $('node name') there are then different options depending on which item you want to get, We have them documented here: Output of other nodes | n8n Docs if you wanted to look further.

[Jonathan]

I used another way, but I have quite too much merges so it’s kinda slow at some point, I’ll try to use {{ $json["name_2"] }} or similar next time. I sometimes use $( 'node.item.json.xxx' ) too. Still discovering but so far, n8n is an awesome service !