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
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 42 Domo News
- 9.9K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 110 Apps
- 726 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 29 お知らせ
- 65 Kowaza
- 302 仲間に相談
- 664 ひらめき共有