Grouping and outputting result

[bobbydave]

Country	Date	Entity	Data
DE	X	A	Test
BE	X	B	test
UK	X	C	test
CE	X	B	Another Test
FR	X	A	Another Test
IE	X	A	etc
PT	X	C	etc
EE	X	A	etc

I have the above table. With Country being my unique identifier throughout my app, I now have one part of the app that depends on the Entity and although Country wont be visible in this next table, it will do the workings dependent on Country

Table_Entity	Table_Index	Table_Data
A		All the data on A
B		All the data on B
C		All the data on C

I want to gather Country dependent on Entity A, B and C and then the output should display the total Data in Table_Data.

Hope I've explained myself.

[awhitfield]

Create a straight table with Entity as the Dimension and Concat(Country,';')  as the expression

Andy

[datanibbler]

Hi bobbydave,

I get it you want to assemble all the Countries which are associated with any of the entities in your second table?

Try the CONCAT() function for that, like

>> Concat([country], ';') <<

=> You will get a field looking like >> Germany;Belgium;Uruguay << (if those countries are associated with your entity)

HTH

[bobbydave]

Something similar to this.

Although you have the last part correct by that would be Concat(Data, ',')

I need to first gather the countries so that Entity A B and C each have so many countries.

I was thinking more set analysis but that only brings back a numeric value, right? Wont work for String?

A might bring back UK, Ireland, Belgium

B might bring back France, Denmark, Germnay

C might bring back Turkey, Sweden, Norway

and from there, it would pick up the relevant data from Column Data and Concat(Data, ',') into Table_Data Column.

so the logic would be

if(

     (if Entity ='A', Country

          else if Entity = 'B', Country

               else if Entity = 'C, Country),

concat(Data, ', '), '')

[bobbydave]

Something similar to this.

Although you have the last part correct by that would be Concat(Data, ',')

I need to first gather the countries so that Entity A B and C each have so many countries.

I was thinking more set analysis but that only brings back a numeric value, right? Wont work for String?

A might bring back UK, Ireland, Belgium

B might bring back France, Denmark, Germnay

C might bring back Turkey, Sweden, Norway

and from there, it would pick up the relevant data from Column Data and Concat(Data, ',') into Table_Data Column.

so the logic would be

if(

     (if Entity ='A', Country

          else if Entity = 'B', Country

               else if Entity = 'C, Country),

concat(Data, ', '), '')

[bobbydave]

Something similar to this.

Although you have the last part correct by that would be Concat(Data, ',')

I need to first gather the countries so that Entity A B and C each have so many countries.

I was thinking more set analysis but that only brings back a numeric value, right? Wont work for String?

A might bring back UK, Ireland, Belgium

B might bring back France, Denmark, Germnay

C might bring back Turkey, Sweden, Norway

and from there, it would pick up the relevant data from Column Data and Concat(Data, ',') into Table_Data Column.

so the logic would be

if(

     (if Entity ='A', Country

          else if Entity = 'B', Country

               else if Entity = 'C, Country),

concat(Data, ', '), '')