Hide a column data fusion
Hi,
Currently handling tremendous set of data in the data fusion, I would like to hide some useless columns. I went to the edit DataFusion where the joins are made and below it should be the place where we are able to hide the rows. However the display won't show. I wonder if it was because of the amount of data that I have : about 300million of rows and something close to 200-300 columns.
Is there any other solution to hide columns from a data fusion?
Thanks a lot
Best Answer
-
Hi @user07367
You should be able to rename and/or ignore unecessary columns in the Fusion editor. Simply click on the arrow next to the column name and select "Ignore Column"
Here's a link with more information: http://knowledge.domo.com?cid=usingdatafusion
Thank you for the screenshot. I suspect that the error is related to the size of the data preventing the preview. Have you tried ignoring the column and then saving the Fusion to see if the change goes through?
Thank you,
Creed
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
Hi @user07367
You should be able to rename and/or ignore unecessary columns in the Fusion editor. Simply click on the arrow next to the column name and select "Ignore Column"
Here's a link with more information: http://knowledge.domo.com?cid=usingdatafusion
Thank you for the screenshot. I suspect that the error is related to the size of the data preventing the preview. Have you tried ignoring the column and then saving the Fusion to see if the change goes through?
Thank you,
Creed
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Hello,
I always hit the same error on DataFusion, exactly the image attached by another user (user07367).
For sure I am still able to save it and go with the blended data, however, the error comes whenever I update, add / replace / remove dataset in the datafustion edit. Without the preview loaded, it is not able to remove extra columns in such case and create a very wide and huge dataset. I think it doesn't make sense to create a new datafusion to facilitate this, especially when we have already created multiple cards with the datafusion dataset. Hope Domo team can provide a solution to this. Thank you!
stay healthy, everyone!
0 -
@Nek here's a tutorial video on how to alter your Fusion using the Java CLI.
https://www.youtube.com/watch?v=9HYx1vn3HRM
In your case you'd want to drop columns under the MAPPING and the COLUMNS clause
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Thanks a lot Jae! However, I don't see 'Security' in my Domo Admin page and not able to get a access token, it should be due to corporate settings, though I am able to download the CLI - will still try it out later anyway. I've also watched your other youtubes before, those are great and super helpful, thanks for your sharing!!
(my current solution is to create extra ETL or SQL to get and rename the data fields required, then blend to the datafusion)
stay healthy!
Nek
0 -
Ask your Domo Admin to generate an access token for you.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"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
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 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
- 103 Community Announcements
- 4.8K Archive