Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I ahve 2 tables. I want to have count on one column of 1st table but i have to put GroupBy function on columns in Second table.
How can we do this??
Thanks
Hi,
Can you explain with example??
Regards
I have table1 :
Item1 , Item2 , Item3
Table 2:
ITem4,
Item5;
I want to have count(Item1) group by item4 , item5 ?
You can to JOIN tables in script using JOIN keyword, as a result you will and up 1 table.
If you still want to keep both tables, Maybe you can JOIN them in a temp table and bring back the aggregated value to one of the table by ApplyMap or another Join
Don't they have any common field ?
Nope
Hi
I think they must have a common field otherwise your count will be meaningless.
If you can't share data with us, perhaps you can use sensible field names instead of Item 1 etc., so that we can help you.
Hi,
can i know how do you do this manually??
Please post sample data with required output.
Regards,
Hey,
ALso i would like to know that, In pivot table ia hve 3 dimensions and 1 expression as COunt(Item). Now i want to execute same by sql query.
So in sql query do i have to use group by including all the dimensions that ahve been used??
Well, perhaps we can get the COUNT working first and then you can decide how best to use it.
I suspect your dimensions are the common fields you need to join your tables ?