Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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
load ID, concat(Room, ', ') as Rooms
from yoursourcetable
group by ID;
Worth putting a 'distinct' in there so it doesn't repeat values (if that is a possibility)
Concat( distinct Room,',')
I agree. I will edit my response.
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
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
];