Loop query to Update DB

[Miotx]

Hello All,

I am using a Retool Workflow to run a loop to update/insert a record into my Retool DB.

For the filter, I am using a mix of 2 values for my id as shown but when inserting the record, it only inserts the first value.

Below is my Workflow is below and I circled what the value inserted should be but instead it only inserts the value.restaurant:

Below is my DB showing the inserted record:

What am I doing wrong here?

Thanks,

[ZeroCodez]

Hi @Miotx, You can use {{ value.restaurant }} + '_' + {{ value.businessdate }}

[Miotx]

Thanks for the tip! I adjusted it to the below and it worked like a charm!!

{{ value.restaurant + '_' + value.businessdate }}

Thanks!