The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Concatenation of multiple column data into One.
achint_kumar
Member Posts: 16 
Contributor II
in Help
Hello
I want to concatenate some attributes one below the another. The final input in two columns, one for Column header and other for Data from all columns.
Something like this:
Source data(Already transposed):
ColumnName - att1 - att2 - att3 .....................- attN
1 - ABC - GHI - MNO - ZZZ
2 - 123 - 456 - 789 - 999
3 - DEF - JKL - PQR - YYY
Output Required:
ColumnName - attrNew
1 - ABC
2 - 123
3 - DEF
1 - GHI
2 - 456
3 - JKL
1 - MNO
2 - 789
3 - PQR
.
.
.
...
1 - ZZZ
2 - 999
3 - YYY
I want to concatenate some attributes one below the another. The final input in two columns, one for Column header and other for Data from all columns.
Something like this:
Source data(Already transposed):
ColumnName - att1 - att2 - att3 .....................- attN
1 - ABC - GHI - MNO - ZZZ
2 - 123 - 456 - 789 - 999
3 - DEF - JKL - PQR - YYY
Output Required:
ColumnName - attrNew
1 - ABC
2 - 123
3 - DEF
1 - GHI
2 - 456
3 - JKL
1 - MNO
2 - 789
3 - PQR
.
.
.
...
1 - ZZZ
2 - 999
3 - YYY
0
Best Answer
-
BalazsBarany
Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert Posts: 955 
Unicorn
Hi,
check out the De-Pivot operator.
Regards,
Balázs7
