ROW COUNTING/GROUPING

[mycognosangel]

Hi
I asked a similar question earlier, but the solution I was offered didnt seem to work.
In the TABLE1, the first row has 2 occurences, the second row has 3 occurences in the table and the third row has just 1 occurence. I want an output like INTENDED OUTPUT table based on the TABLE1 information. Pls I need a clear and detailed solution and explanation

TABLE1
Country            Size             key
Holland             1020           Holland1020
France               800            France800
Estonia              300            Estonia300
France                800           France800
France                800           France800
Holland             1020           Holland1020

INTENDED OUTPUT
Country           Size              Key                 Count
Holland             1020           Holland1020        2
France               800            France800            3
Estonia              300            Estonia300          1

[Lynn]

Hi
I asked a similar question earlier, but the solution I was offered didnt seem to work.
In the TABLE1, the first row has 2 occurences, the second row has 3 occurences in the table and the third row has just 1 occurence. I want an output like INTENDED OUTPUT table based on the TABLE1 information. Pls I need a clear and detailed solution and explanation

TABLE1
Country            Size             key
Holland             1020           Holland1020
France               800            France800
Estonia              300            Estonia300
France                800           France800
France                800           France800
Holland             1020           Holland1020

INTENDED OUTPUT
Country           Size              Key                 Count
Holland             1020           Holland1020        2
France               800            France800            3
Estonia              300            Estonia300          1

What was the other solution offered and what was the problem with the result? Is your package relational or dimensional?

Is your query set to auto group and summarize? If it is I would expect that you would only see the three distinct rows. Is there anything in your data source that uniquely identifies a row?

You can try a query calculation that uses a count function using country as the scope in the "for" clause. To get a correct result you may need a value that uniquely identifies each individual row. In your case, the "key" is not uniquely identifying a row.