Findrow in 2 different tables

I have 2 tables Table 1 and Table 2. Table 1 has incoming data and Table 2 has the data I want to keep.

I want to add an item to table 2, then with an automation delete the item from table 1(It has to exist in table 1 to be added to table 2).

I have tried in the automation to delete when row added to Table2

I am obviously missing something, any help would be appreciated.

Hi @Buildit123,

Thanks for reaching out.

You can achieve the desired output using below query:


Hope this helps, feel free to reach out if you have any more question.

Thanks, that worked.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.