Flow to check if record does not exist in table, to import the record in?

Question

I have a table (created by combining a set of Excel files in a folder) that has a column called call_id. I have created a separate table in SSMS that is stored in a database that has a column for call_id as well. I want to create a flow via Alteryx Designer that would check if a call_id record does not exist in my first table, and if it doesn't, then import it in the second table (in the database). How would I go about creating this conditional check with the second table being in a database? I am new to Alteryx and am still learning the various connectors.

kenkie · Answer

add summarized and change the anchor from joins.

call_data_dump.yxmd

ninosshiba · Answer

Thank you. Table A is also made up of several duplicate records (since each day a new file is uploaded for the data, but the previous file is not overwritten). How do I add a check to check for records from Table A that already exist in Table B, to update the records in Table B with the LATEST data from Table A for each record?

For example, call_id 123 already exists in Table B. In Table A, another file was uploaded that has more recent data for this call_id. How do I update call_id 123 in Table B with the LATEST file date for this record from table A? Hopefully that makes sense.

kenkie · Answer

Hello @ninosshiba , try this one. @ArtApa is correct, join helps...Ü

call_data_dump.yxzp