How do I Group Text Values Together from Multiple Records

[patbuchanan]

I have a table that has multiple records for and ID based on how many Rooms are associated to that ID and I'm trying to present one record for each ID that has all the Rooms associated with the ID combined in one field.

So, I'm trying to convert:

To:

[simenkg · Accepted solution]

Depends on where you want to do this.

In script:

Load ID, Concat(distinct Room,',') as [Room(s)]
From Table.qvd (qvd)
group by ID;

In chart.

Dimension: ID
Expression: Concat(distinct Room,',')

Regards

SKG

[maxgro]

load ID, concat(Room, ', ') as Rooms

from yoursourcetable

group by ID;

[JonnyPoole]

Worth putting a 'distinct' in there so it doesn't repeat values (if that is a possibility)

Concat( distinct  Room,',')

[simenkg]

I agree. I will edit my response.

[ashfaq_haseeb]

Try this

Load ID,Concat(Room,',') as Rooms Group by ID;

Load * Inline

[

ID,Room

100,Room1

100,Room3

101,Room1

101,Room2

];

Regards

ASHFAQ

[#7]

HI Pat hope you help this

Try this both

In script:

Load ID, Concat(distinct Room,',') as [Room(s)]
From Table.qvd (qvd)
group by ID;

or

Load ID,Concat(Room,',') as Rooms Group by ID;

Load * Inline

[

ID,Room

100,Room1

100,Room3

101,Room1

101,Room2

];