combining multiple columns into single column

User: "Anusha"
New Altair Community Member
Updated by Jocelyn
Hello Everyone,

I'm trying to combine the necessary columns with a delimiter as "," into a single column, but I'm unable to do that. can anyone please help me?

eg: input data: no of columns=5
reg no      text1      text2     text3         text4
1               an         apple     keeps       away
2               The        sun       rises         in

required output: no of columns=2

reg no       full text
1               an, apple, keeps, away
2                The, sun, rises, in


Thanks in Advance!

Find more posts tagged with

Sort by:
1 - 1 of 11
    User: "kayman"
    New Altair Community Member
    Accepted Answer
    Updated by kayman
    @Anusha, Try as with attached. The aggregate operator contains a 'hidden' concatenation option which does exactly what you want.
    It's comma separated now, but you can easily change the comma to |: or whatever you prefer.