Home
Discussions
Community Q&A
Concatenation of multiple column data into One.
achint_kumar
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
Find more posts tagged with
AI Studio
Accepted answers
BalazsBaranyRM
Hi,
check out the De-Pivot operator.
Regards,
Balázs
All comments
BalazsBaranyRM
Hi,
check out the De-Pivot operator.
Regards,
Balázs
Quick Links
All Categories
Recent Discussions
Activity
Unanswered
日本語 (Japanese)
한국어(Korean)