Combining values in 3 columns into 1 new column
I have 3 columns of dates (for example purchase date of: Column 1 - Apple , Column 2 - Pears, Column 3 - oranges). I want to create a new column that combines all 3 of these column dates to display a single column of dates. This is to be used for another set of data analysis (where the date is important and needs to be combined).
Is this possible and an easy solution? Thanks.
Comments
-
I'm not sure exactly how this would work well, having 3 dates that represent different things all in one column. Seems like it would be hard to re-use later on because I doubt it will even register as a date field probably just string. You can however use the "Combine Columns" ETL block to achieve what you're asking, but definitely think about how you would analyze this later.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**1 -
If you want to do this at the card level, you could also concatenate the three columns in a new calculated field.
I attached a picutre of how this would work (the fields in blue are my sample date fields). The new field, Combined Dates, would appear at the card level (you could also select to share it on the data set and it would show up on all other cards built off that data set).
I hope that helps!
0 -
Tell me if I’m understanding this correctly. You have three columns with dates in them and you need to keep all of the data but have only one date field?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 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