LinkedIn
Twitter
Hi All,
I'm trying to create an automation that adds rows to a table. It is a scheduled automation that checks ros on the table for matching criteria and then creates new rows if the criteria match. The automation worked when my data was stored in google sheets. However, since I moved everything to bigquery I get an error that regards my row IDs.
The automation is set up like this: I create a scheduled event with ForEachRowInTable selected
I then add an action that adds rows to the table.
I had added filter conditions to the event. but this led to the BQ error in the first screenshot. I also tried adding the filter conditions to the action, but got the same error. I'm not referencing the ID column in any of the filter conditions since I want the new rows to be added only if an existing column has a matching month and year. What confuses me is why this used to work correctly when my table was stored in google sheets. Also, why is BQ referencing the ID column as "@A1","@A2", etc.
The monitor give me the following error for the process:
Sorry if i didn't explain the issue properly. New at this so going a bit crazy. If anyone could provider any help that would be great!
