In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Merge of records based on the record name

jmedidi
8 - Asteroid
‎01-28-2022 07:30 AM

Trying to merge the records. appreciate the support

 

Existing :

DESCRIPTIONRESPONSE
Year2024
ProgramT555
Module NameTECM
Release Date10/7/2019
Program MilestoneDVP
Year2025
ProgramV720
Module NameMCCE
Supplier's Company NameABC
Supplier's Release Engineer's Namedummy@company.com
Release Date3/5/2020
Program MilestoneTRE

 

Desired

 

DESCRIPTIONRESPONSE
Year2024, 2025
ProgramT555,V720
Module NameTECM, MCCE
Release Date10/7/2019, 3/5/2020
Program MilestoneDVP,TRE
Supplier's Company NameABC
Supplier's Release Engineer's Namedummy@company.com
Labels:
Reply
1 REPLY 1
atcodedog05
22 - Nova
22 - Nova
‎01-28-2022 07:40 AM

Hi @jmedidi 

 

You can use summarize and merge the rows like below. Highlighted is the seperator

 

atcodedog05_0-1643384379165.png

 

Hope this helps : )

 

concat.yxmd
Reply
Labels
Top Solution Authors
View All