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?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive