How do I remove the 'Total' row from a data import?
I am using a connector to pull data in from one of our web analytics platforms. The problem is that it pulls in a 'Total' row which I can not suppress at the source. Using an ETL how do I remove that row? I've tried to use the Filter Row tile but perhaps I am doing something wrong there because I have not been able to remove the 'Total' row.
Best Answers
-
If there is some way to uniquely identify that row, then you can do as you suggested and use the filter tile in Magic ETL. There are two ways to filter rows using the tile, with a formula rule or with a filter rule. Here is a knowledge base article that walks you through how to use it:
If you still can't get it, please post a screenshot of the configuration of the filter tile.
If I solved your problem, please "accept" my answer as the solution
2 -
You still need to use the filter tile, not the formula tile. However, within the filter tile there are 2 options for filtering: Formula or Filter rule. The filter tile allows for multiple conditions and even a combination of both formula and filter rules. Remove any other conditions/rules and just leave the:
`Marketing Category` != 'Total'
If I solved your problem, please "accept" my answer as the solution
0
Answers
-
If there is some way to uniquely identify that row, then you can do as you suggested and use the filter tile in Magic ETL. There are two ways to filter rows using the tile, with a formula rule or with a filter rule. Here is a knowledge base article that walks you through how to use it:
If you still can't get it, please post a screenshot of the configuration of the filter tile.
If I solved your problem, please "accept" my answer as the solution
2 -
This row
And this is the rule I am using
0 -
Using a formula rule in the filter tile would be:
`Marketing Category` != 'Total'
If I solved your problem, please "accept" my answer as the solution
0 -
In addition I am finding a 'Total' value in the Marketing Category column for every of data in the report.
0 -
Interesting. The formula works and moves the rows with 'Total' but then converts the column to an integer from text.
0 -
That is odd, you can convert it back using the Alter Columns tile.
If I solved your problem, please "accept" my answer as the solution
0 -
Tried that. I am also noticing that not only does it remove 'Total' but the formula removes any text based values. I'm just not sure what is going on here.
0 -
Filter tiles allow for multiple conditions. Have you removed your other filter rule from the filter tile?
If I solved your problem, please "accept" my answer as the solution
0 -
I swapped out the filter tile for the formula tile and used the formula you provided.
0 -
You still need to use the filter tile, not the formula tile. However, within the filter tile there are 2 options for filtering: Formula or Filter rule. The filter tile allows for multiple conditions and even a combination of both formula and filter rules. Remove any other conditions/rules and just leave the:
`Marketing Category` != 'Total'
If I solved your problem, please "accept" my answer as the solution
0 -
Oh wait. There is my error. I just swapped back to the filter tile and noticed that there is an option to use a formula. I missed that last time. Putting the formula in the filter tile seems to work. Thanks for the help.
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive