Aggregations in script without Resident

[#1]

Hi,

I want to create a simple a aggregation like Count in the script,

but i can't use resident, is it possible?

the table looks like that:

Load item_code

        store_code

From [..\Qvd\Fact_Current_Prices](qvd);

I need to count the number of items for each store,

i have to do it in the script and without using resident (though it's working with resident)

Thanks.

[andrespa]

Hi Roman, why you don't do it in the same table, like this:

Load

         item_code

         count(item_code)               as No_items,

        store_code

From [..\Qvd\Fact_Current_Prices](qvd)

group by

item_code,    

store_code;

[marcus_sommer · Accepted solution]

Shouldn't it not more look like?

Load

         item_code,

         count(item_code)               as No_items,

        store_code

From [..\Qvd\Fact_Current_Prices](qvd)

group by

item_code,    

store_code;

This meant without item_code unless within the aggregation.

- Marcus