Union in Calcuation View

[Former Member]

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,

[Former Member]

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.