Transform Saved Wrong
I have a "create table" transfrom in a dataflow, with "Generate Output Table" unchecked. It runs fine & applies fine. But once the dataflow is saved, "Generate Output Table" becomes checked, and "Create Table" is cut off from the SQL.
See image attached. This is something newly noticed.
Comments
-
I'm not sure what is gained by trying to uncheck the generate output table when the function you are writing the code for is to create a table.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
Hi,
Great question @ST_-Superman-_. I do think that "generate output table" only applies in DQL (Data Query Language) commands. Being "CREATE" a DDL (Data Defenition Language) command it does not result in a table, it creates a schema for a new table, different thing in terms of results.
Anyhow, in my view DOMO should not reactivate the "generate output table", but I have a theory for this:
All Transforms with "generate output table" checked are in fact "Create Tables", and somehow DOMO is parsing the text and converting it to a normal transform as it drops the "Create Table" and names the table "IF"... just my two cents here!
A workaround could be to create the table via a normal query and filter it with the same condition that controls the creation of the table in the first place, the difference would be that the table would exist but empty of rows.
Hope this helps.
Ricardo Granada
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.1
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 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
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive