[image] from this flow, i want to comapre output of speech to text and DB_MYSQL. But both output show in msg.payload (although i have change the msg.payload of speech to text to transcription by using Transcription, it also will become msg.payload) So, how to do setting in compare data ? that mus…

A few options but perhaps a quick way is to use a change node right after your transcription node and change it’s msg.payload to msg.topic then you can compare msg.topic and msg.payload on your switch node.

[{"id":"98f4cc17.965b","type":"tab","label":"VAES","disabled":false,"info":""},{"id":"ee60c3e3.69e03","type":"mysql","z":"98f4cc17.965b","mydb":"7c738c44.e9a364","name":"DB_MYSQL","x":470,"y":100,"wires":[["df7c1555.276f08"]]},{"id":"5d766314.29f91c","type":"function","z":"98f4cc17.965b","name":"rea…

If you want to compare the values in two separate messages, you first need to join them together into a single message. The Join node can help you do that. There is an example on the cookbook that may help you: https://cookbook.nodered.org/basic/join-streams

You could try using a join and then compare strings with Jasonata. This is just one of many ways and gets you started with Jasonata, which is a very powerful tool to use in Node-Red. Here's a sample flow on how that may work. It will produce true or false depending on the result of the comparison. …

Thanks Steve, Much appreciated... Here we go. [{"id":"66a036e5.83f9b8","type":"inject","z":"4e88b55c.0c5b9c","name":"","topic":"","payload":"String A","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":390,"y":160,"wires":[["195170d6.128d9f"]]},{"id":"bd0cfb82.f14688","…

Thank you , it help me But if i compare the data with a string in an array, how can i compare it? [image] [image] in picture above i want compare hello hello hello from speech to text with database ...but in database is in array. how can i compare one by one?

a quick google search came up with this: https://www.geeksforgeeks.org/how-to-check-if-a-variable-is-an-array-in-javascript/

Without seeing what's in your array[10] it's a bit hard to offer an idea. In the idea I posted earlier, with an attached sample flow, this suggested a Jasonata $string() function comparison to do the job (see below). The result is "true" of "false". This uses the Jasonata $string() function which …

Node-RED

Node-RED Forum

How to compare two msg.payload in a same flow

General

Steve-Mcl 7 May 2020 06:24 7

Please read how-to-share-code-or-flow-json

Topic		Replies	Views
How to get "text" from "speech to text" that needed using in function node General	18	2785	16 June 2020
How using msg.topic, payload and transcription in compare data in switch node General	5	878	23 June 2020
I have some questions relating database General	57	3764	3 December 2018
Generate SQL statement from 2 mqtt messages General	42	1086	20 July 2020
Object Sqlite Query, Add Some Data & Merge General	17	655	12 April 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

How to compare two msg.payload in a same flow

Related topics