This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am new to Alteryx and need to take a daily feed input file (excel) search for specified key to see if it already exists in a SQL Table.
If it already exists, i need to update the SQL Table. Otherwise it will need a new record inserted into an existing table.
If anyone has already done something like this and willing/able to share with me how that was done, it would be appreciated so much. I'm just not sure how to start even though i did complete the learning in the academy section. :( Sorry - so your help is needed and appreciated.
Yes, the simple solution above will require downloading the data and then fully overwriting the old table.
In order to achieve your two points below you can tinker with the configuration of the Output Data tool. In Row 3 of the options window - 'Output Options' - you will see you can Append, Update, Overwrite rows in the database. With this you can update the fields you want and then also append the new ones, likely in separate Outputs (from the Join and from the Right).
I recommend you experiment with these on a trial table in your DB.