Forum Discussion
Summarizing one table in a new table
I thought i did that in my last reply Zubair_Muhammad 😉
I gave you more information and a screenshot of all the cities but im missing the projectnames, they are in a different table.
Is it possible to create a new table with a colum with the projectname and 1 column with the unique cities for each projectname
I can't attach an excel file but it's not that difficult what im asking but let me try again.
I have one table with 40.000 rows in them.
Every row has a City and a ProjectName in them
Both City and Projectnames are NOT unique
A City is always in a Project and a project is always in a city
What i need is the following
A new table to summarize that is Project A has 12000 rows and has 10 unique rows
A summarization of the unique City names per Projectname
So if Projectname A has 12.000 rows in the table but has 4 unique Citynames then the result should be
Project A City A
Project A City B
Project A City C
Project A City D
If the next Projectnam has 8000 rows and 2 unique cities, the result should be
Project B City D
Project B City E
As you can see City D is both in Project A as in Project B and that is what i need
I need a complete summarization (in a new table) of all 40.000 rows
Please send me your Excel File.
I think Distinct(TableName) should do the job. Because it looks at distinct row...not a particular column
Hi RvdHeijden
Please try this calculated table based on the file you sent
Table = VAR mytable = SELECTCOLUMNS ( Blad1, "Hoofdproject", [Hoofdproject], "plaats", [plaats] ) RETURN DISTINCT ( mytable )