Default Values for a column
Hi DOMO Community,
I want to put a column on a dataset that defaults to 0. That column will be updated by a python script to 1. But on new data rows being added, it still defaults to 0 without overwriting the 1 rows
Note that this will be in Magic ETL
Answers
-
What's the fashion that your data is coming in? Would you be OK with doing some sort of recursive/append that stands up the new column as zero on the new data rows side, but preserves the 1 setting on legacy rows that have been touched by the python script? Tough to tell without knowing more, but I'd anticipate some degree of separation of new rows (0) and existing rows (1) that are handled differently via some config of filters & appends.
0 -
A few questions:
- Is the Python script updating the output dataset post-Magic ETL in order to update the column to 1?
- Is the output then brought back into the dataflow as an input? (thus creating a recursive dataflow)
- How are new rows added? (Via the original raw input dataset, perhaps?)
- Are the new rows ever updates to historical rows? Or are they net new?
I have a couple ideas but I want to make sure I understand what the pipeline looks like so I don't advise you incorrectly.
Domo Product Manager for Data Transformation (MagicETL)
0 -
I actually abandoned this route to go in a different direction. I appreciate you all helping.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 713 Beast Mode
- 50 App Studio
- 39 Variables
- 669 Automate
- 170 Apps
- 447 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive