Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Karl_Hart,
Use left join instead of Concatenate
left Join(SiteOwner)
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!
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