Concatenate Rows

[#1]

Hi every one we have a typical requirement We have following data

User ID	Name	Device
80004022	ABDUL AZAM	868438010471186
80004022	ABDUL AZAM	868438010471186A
80001571	ABDUL AZIZ	868438010470071
80001571	ABDUL AZIZ	868438010470071A
80001571	ABDUL AZIZ	868438010470071B
80001594	AKHLAQ AHMED	868438010470147
80001594	AKHLAQ AHMED	868438010470147A
80001594	AKHLAQ AHMED	868438010470147B
80001594	AKHLAQ AHMED	868438010470147C
80001591	ASIM IQBAL	868438010471145
80001591	ASIM IQBAL	868438010471145A
80001591	ASIM IQBAL	868438010471145B
80001591	ASIM IQBAL	868438010471145C
80001705	IMRAN UL HASSAN	868438010464702
80001705	IMRAN UL HASSAN	868438010464702A
80001705	IMRAN UL HASSAN	868438010464702B
80006221	MUHAMMAD AHMED KHAN	868438010467937
80006221	MUHAMMAD AHMED KHAN	868438010467937A
80001703	RAJA TALLET IMTIAZ	868438010463480
80001703	RAJA TALLET IMTIAZ	868438010463480A
80001703	RAJA TALLET IMTIAZ	868438010463480B
80000756	RIZWAN MALIK	868438010471046
80000756	RIZWAN MALIK	868438010471046A
80000745	SHOUKAT IQBAL	868438010465857
80000745	SHOUKAT IQBAL	868438010465857A

We want to show User wise all devices in one row like below

User ID	Name	Devices
80004022	ABDUL AZAM	868438010471186, 868438010471186A
80001571	ABDUL AZIZ	868438010470071, 868438010470071A, 868438010470071B
80001594	AKHLAQ AHMED	868438010470147, 868438010470147A, 868438010470147B, 868438010470147C
80001591	ASIM IQBAL	868438010471145, 868438010471145A, 868438010471145B, 868438010471145C
80001705	IMRAN UL HASSAN	868438010464702, 868438010464702A, 868438010464702B
80006221	MUHAMMAD AHMED KHAN	868438010467937, 868438010467937A
80001703	RAJA TALLET IMTIAZ	868438010463480, 868438010463480A, 868438010463480B
80000756	RIZWAN MALIK	868438010471046, 868438010471046A
80000745	SHOUKAT IQBAL	868438010465857, 868438010465857A

Is this possible? Thank you

[er_mohit]

on expression side

aggr(concat(Device,','), [User ID], Name)

[#3]

Thank You Manish for your time.

Means you say if we want to extract via script it will always take time to reload. no help on this..

Ok Thank you for all

[MK_QSL]

Reload time will depends on your Data. Here your have 10M rows and due to grouping it is taking more time.

But if you use the same CONCAT function in Table/Chart instead of Script, it will take more time for everytime you select/deselect your dimensions.

[#5]

Exactly that's why we need to work on script rather then use Table/Chart but as you say it will always take time due our data we can't do anything on it....

[rbecher]

But you could limit UI activities with conditional views etc. For instance, show only the concatenated devices if one user (or something else) is selected. From my point of view it makes no sense to lose details and do this transformation on script.

[#7]

Becher,

Conditional view is for just hide or show the chart not limit the records..

If you look out the data we are not losing any detail we have all record in the data in the form of 1 row.

[rbecher]

I meant it is not a problem to have may records. It is a problem if you provide a wrong UI.

And, how do you count Devices then if you want to know it for some aspects?

[#9]

If we want to count devices, simple we count ","+1 in Devices because it separate the devices

[rbecher]

Interesting. Tell me how you wanna do this? Do you think string operations are faster than counting field values??

[#11]

Ralf,

First of all we don't want to count No of devices once we need this i prefer to find Length of the field and work with that because Len function is much faster then Count But if we need to count No. of devices but we dont want that.