Data delete and append option for selective folder data

[Yogi]

Hi There,

I am new to Alteryx. I have a scenario where I have to extract Coordinates Data of building site and inserted into DB. it is working fine.
Now I have to insert 2 building data and I want to insert and update only one building data. If I use Delete and Append when inserting Data in DB than all data delete and insert only one building data. and second building data is deleting.

Instead of this I want to insert data as per the site name so if I insert only one building data than only one building data can delete and append and other building data remain same as it is.

Example:

Building Name	Location 1	Location 2	Location3	Create By	Site Name
AND	12	12A	12	YOGI	Android
AND	12	12A	12	YOGI	Android
AND	12	12A	12	YOGI	Android
IOS	23	12A	23	YOGI	Apple
IOS	23	23B	23	YOGI	Apple
IOS	23	23B	23	YOGI	Apple
AND	22	22D	22	YOGI	Android
AND	22	22D	22	YOGI	Android
AND	22	22D	22	YOGI	Android
IOS	11	11F	11	YOGI	Apple
IOS	11	11F	11	YOGI	Apple
IOS	11	11F	11	YOGI	Apple

Here I want to insert only selected building data so first delete and insert selected building data.

Thanks &Regards

Yogesh Chouksey

[Yogi]

Hi Aleryx Team,

Please help to understand and solve this problem 

[TrevorS]

Hello @Yogi 

Can you please include a copy of your workflow and what you have attempted so far?

This will help the Community to better troubleshoot where you are stuck.
Thanks!

[Yogi]

Smile Thanks @TrevorS for reply.

The problem is solve.

I have created Macros for this to Delete data first before inserting data in DB.
I have use "Control Parameter"  In the Action Tool I have set "PostSQL" statement to delete data based on unique column "Site name".  

I use this Macros in My main Workflow to delete data first for this I have use "Block Until Done" so Match data delete from DB after that Main Workflow Insert new data in DB.

Regards 

Yogesh Chouksey