Trying to condense / group rows to remove nulls, any help appreciated
Hello,
I am working on a data flow that needs to perform various substring functions to isolate data from a large xml string.
I have gotten it close, where the data is linked to the log / time / user in in the sql database, and i am able to separate values into appropriately named columns.
I would like to know if/how to condense these rows so that the nulls disappear, and only the log, starttime, logged in user (these should be the same across all rows that have the same log)(log is unique so there will not be more than one row that has a value)
Please see picture below:
Thank you!
Best Answer
-
Group by your log start time and logged in user and take the max values
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Group by your log start time and logged in user and take the max values
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
Thank you for your reply @GrantSmith
I ended up using a series of joins, but your advice is useful for the final card that will display the data.
take care!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive