topic Re: how data from query multiple rows assign to single variable as comma separted in App Development

how data from query multiple rows assign to single variable as comma separted

gsethuraman2 — Thu, 25 Jul 2019 18:11:50 GMT

I need something like this ..

set vPERSONID=Aggr(Concat(DISTINCT PERSONID, ', '));

Query Output from database

PERSONID

28987

145672

675432

i need something like this in below variable ..

vPERSONID=(28987,145672,675432)

Re: how data from query multiple rows assign to single variable as comma separted

Ezirraffner — Thu, 25 Jul 2019 18:29:53 GMT

set vPERSONID=Concat(TOTAL PERSONID,', ')

Re: how data from query multiple rows assign to single variable as comma separted

Ezirraffner — Fri, 26 Jul 2019 11:44:08 GMT

Hello @gsethuraman2

Did it work?

Re: how data from query multiple rows assign to single variable as comma separted

mahaveerbiraj — Fri, 26 Jul 2019 12:17:44 GMT

Refer below example

Data:

Load * inline

[

Num

];

TempConcat:

LOAD Concat(Distinct Num,', ') as TempNum Resident Data;

Let val = FieldValue('TempNum',1);

Reply me if your not clear with example.

Re: how data from query multiple rows assign to single variable as comma separted

gsethuraman2 — Fri, 26 Jul 2019 12:28:30 GMT

set vPERSONID=Concat(TOTAL PERSONID,', ');

trace $(vPERSONID);

its printing me as string val - Concat(TOTAL PERSON_IDENTIFIER,', ')

Not sure anything iam missing in the code ???

Re: how data from query multiple rows assign to single variable as comma separted

gsethuraman2 — Fri, 26 Jul 2019 12:31:39 GMT

Yes its getting full set of value thru resident load ..

thanks .. so it solved rather putting for loop for 30 or 40 ID's per manager its taking time ..

so this way per manager ID whoever reports will get his list in single variable thru comma separated and i parse that value to further queries ..

thanks .. it helped ..

Re: how data from query multiple rows assign to single variable as comma separted

gsethuraman2 — Wed, 31 Jul 2019 19:39:27 GMT

TempConcat:

LOAD Concat(Distinct Num,', ') as TempNum Resident Data;

Let val = FieldValue('TempNum',1);

this work for first set of rows .. (i=0 it pulled all comma separated value correctly)

then thru second load which i do in loop i=1 that i parse new variable to the query then i need new comma separted value but iam getting same value as above in that val$(i) .. its because iam using resident load ..as its getting value only for first set correctly

Re: how data from query multiple rows assign to single variable as comma separted

gsethuraman2 — Wed, 31 Jul 2019 20:15:32 GMT

Getting data for iterative loop worked .. By dropping loading data

for example i=0

set the comma separted value then after in the bottom i dropping

DROP Table Data;

So next time with new i val its getting new set of comma separted value ..

thanks ..