DataFlow ETL to change column values based on values in another column
We recently discovered a data tracking issue that affects one of our datasets.
The result is that the Revenue values have become meaningless after 24th April 2018. The other columns of data are ok and are still required.
My aim is to change the all Revenue values to 0 when the date is greater than or equal to 24th April 2018.
I have been trying to do this in a DataFlow but have been unsuccessful so far.
I attach a screenshot of how the table is structured.
Any ideas of what to use in the flow would be much appreciated. Thanks
- 10.7K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 302 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board