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.
0 -
I actually abandoned this route to go in a different direction. I appreciate you all helping.
0
Categories
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 470 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 193 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 174 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive