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
-
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
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 105 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有