I have joined two datasets. Then I have blended an additional data set which contains some static variables.These statics variables are the categories of our clients.
The challenge that I am facing is that the table calculations that I am performing only seem to work properly when I use the category called clients. Which is the one I used to blend the data sets. If I try to do the same calculations using employee type instead, it is not working properly. However if I edit the data connection and use employee type instead, it works.
I should have said that the categories are the exact same ones for employees and clients.
Please attach workbook here.
May be both the data set have employee with some issues. Go with employee type and get report must work.
Now we have union and cross join option is there then why you go with blend now.