you can try this,
use the "Output Data" tool in Alteryx. In the configuration window of the tool, you can specify the database connection, table name, and columns to insert data into. You can also select the option "Enable Write Back" and specify the primary key column of the table.
Once you have configured the "Output Data" tool, you can connect it to a "Select" tool that retrieves the newly inserted record based on its primary key value. You can then use the "Record ID" tool to generate a new ID for the connecting table and combine it with the retrieved primary key value using a "Join" tool.
