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.
0 -
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
MajorDomo@Lusiaves
**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
- 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
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 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