Chart with unrelated Dimension & Expression

[Karl_Hart]

All,

I have a Data Table which has been produced by concatenating two sets of data together, lets call them DataSet1 and DataSet2. Some fields are common but not all. 

I now want to create a chart that has multiple dimensions, some that are common to both data sets and some that are only found in DataSet1. The expression is looking at data from DataSet2.

I cannot get the dimensions from DataSet1 to show in the table. I've attached a very basic example. 

Is there a way of tweaking the expression to get it to show all the dimensions?

[prabir_c]

Hi Karl_Hart,

Use left join instead of Concatenate

left Join(SiteOwner)

[Karl_Hart]

Thank you for your feedback. I would have said in my original post but the attached file is just a simple example of my problem. My real data is concatenated and cannot be left joined

[prabir_c]

Hi Karl_Hart,

Is it mandatory to concatenate two table?

If not we can achieve this using applymap function.

Please check attached.

Hope it Helps!

[Karl_Hart]

Thanks for the suggestion. Although your solution works for my small example, in reality I have two huge tables of data that I am concatenating together, so changing the data structure (by left join of applymap) isn't an option for me. I'm looking for a solution in the front end