-
Goal: I have two separate data sources (
mysql
andretooldb
), they have a common field (sku
). The mysql datasource hascustomerId, sku
retooldb hascustomerName, sku
. I'm looking for a way to find thecustomerName
fromretooldb
given customerId, I plan to match withsku
. I will likely maintain this relationship mapping with a retool workflow. -
Steps: I created a retool variable,
sku_list
, that's populated via an event handler, on queryselect sku from mysql where customerId = {{table.selectedRow.data.sku}}
when I selectcustomerId
from a retool table (populated by a query:select distinct(customerId) from mysql
). I'm trying to use variablesku_list
in my query against retooldbselect customerName from retooldb where sku in ({{sku_list.value.sku}})
-
Details: Since retooldb is expecting a list of integers for the
where sku in ()
it's failing because I'm passing an array.
I'm not sure if I'm overcomplicating things, hopefully my goal is clear.
I'm happy to provide further context if requested.
Thanks in advance.