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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 689 Automate
- 177 Apps
- 454 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive