You'll want to go to Edit Relationships and blend the TableID with FEID as shown below. Then drag the appropriate dimensions/measures into the view. You'll see an icon which looks like a chain that show you're joined on those two ID fields. Attached is a 2018.2 workbook and below are the screenshots. Hope it helps! Thx, Don
sample_v1.twbx 43.8 KB
iss this what you wanted
see the attached
I joined the 2 tables vs blending them
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
sample join.twbx 55.7 KB
Yes, that is what I was looking for. Thank you so much.
But I am still wondering if there is a way to make it work for "Source" column as well since "TableID" list the IDs thats in "Source" column too. This would be the case when I wont be using the FEID column or want to use both columns. I hope I am clear in explaining what I am looking for.
Thank you again.
1 of 1 people found this helpful
In that case, you'll want to follow Jim Dehner approach where he joins the two tables in the Data Source Window (not blending). You would connect to your first sheet and drag it into the Data Source Window, then click the Add button to add your next data source (the second workbook sheet) and join them as Jim did on Table ID and FEID (inner join).
I was under the impression you wanted to stay with blending your data but with your additional clarification you'll want to JOIN not BLEND.
Hope that helps? Thx, Don
Are you going to TC18?
Not this year but will make next year. I’m stuck in Southern CA with some clients. Hope to see you at TC19 tho’! D
Sent from my iPad
Thank you very much Mr. Jim and Mr. Don. It worked for me now