on 12-04-2013 8:57 PM
Hi,
Union in Calcuation view returns all rows from all nodes.
Is there anyway you can collapse the data created in Union, another word, can I make union that joins the data using keys?
I've included a simple example where I unioned two tables.
TBL 1 (key, name, age)
TBL 2(key, city)
When I union them I get a result set that looks like
Key Name City Age
1 Hyun 20
2 Bo 25
1 carrollton
2 flowermound
My desired result would b
Key Name City Age
1 Hyun Carrollton 20
2 Bo Flowermound 25
I know I can do this in anlaytical view as join, but the real requres some aggregation nodes before union, so I need to do this in calucation view.
I'm hoping to accomplish this without using joins in Calc view. is this possible?
Thanks,
Well, you could do UCV just on the key field(s) and the measures you need. Create separate nodes that store the keys and respective dimensions, and join them back in after the aggregation.
No idea how helpful this approach would be - depends on lots of factors such as dataset sizes, what fields make up your keys, etc.
Also, you may want to consider whether or not you can join the data in an ETL flow into one table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.