Reverting values to its original on specified date. using SQL in alteryx.

Question

Hi Everyone,

This is my first post on this community.I have recently started Alteryx Automation and Im loving it so far.

I connect to a aSQL server using alteryx to get data from the server to change values of specific column that have been populated for some given condition.

I will change these values manually and re-run it the next day and so on.

I would have to revert back the change after the date that has been specified in the data.

for better understanding Ill share an example

lets take today as (11/11/2021)

* data fromSQL server - change value from 23 to 25

column Avaluedate to be reverted 12352312/11/202112322312/11/202112222511/11/202112352313/11/2021

change the value from 23 to 25 , and back to 23 on the date specified on column C

****IMPORTANT**** If there are 25 on the value column ( B ) - check for when to revert ( date column ) and revert it back respectively .

Now can anyone assist me on automating the process of reverting the data from 25 to 23 on the date specified. I am stuck in this for weeks and cannot move forward.

pitch in any solution that is relevent that might help.

Thanks in advance.

Pickaxe · Answer

The data is populated from a SQL server. Based on the pre defined conditions.

The logic to automate - whenever the date column is today's date and if we have any 25's in column B we have to change it back to 23 in sql server's table

FYI  we would have changed it to 23 in the first place . The date determines the change.

Pickaxe · Answer

Thanks a lot.

Will try it out😊

drew9 · Answer

Hi @Pickaxe , can you please give a better example of what exactly you need the data to do? I'm not understanding the first table you provided. What is the logic that needs to be automated? Where do the values 23 and 25 come from? How is the date chosen and what determines what it changes to?