Automatically update the column value by current month and year in Magic ETL
hi guys,
I got a table on below and some columns using month/year as column name.
i would like to make an automatically Magic ETL and set a logic condition like below:
if the date(column name) < current month and year (let say 08/2022)
then all value would be clear as 0 value under the column (01/2022, 02/2022, 03/2022......07/2022) and the value under 08/2022, 09/2022....12/2022 would not changed.
the goal is i dun want to change the data structure.
could someone give me some advice on it?
Answers
-
Hi @nica_tc I don't believe there is a way to dynamically name columns in ETL, and having that many columns would likely be messy to manage anyway (one month's worth of data would result in 30 individual columns and you'd have to manually edit cards every time you want to add a day). I recommend keeping a separate date column and creating a pivot table card instead. The benefit of this is that it's also much easier to filter by timeframe and add dates.
2 -
hi @MichelleH,
Thank you for the advice.
in additional, if i keeping a separate date column and creating a pivot table card, for this pivot card is it possible to make as a input dataset for further processing?
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 601 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 689 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 385 Distribute
- 110 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 112 Manage
- 109 Governance & Security
- 8 Domo University
- 25 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive