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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 302 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 633 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 760 Beast Mode
- 62 App Studio
- 42 Variables
- 699 Automate
- 181 Apps
- 457 APIs & Domo Developer
- 51 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive