2 Replies Latest reply on Aug 18, 2016 3:04 PM by gabriela..zorrilla

Populate empty cell with data from other datasource.

gabriela..zorrilla Aug 17, 2016 3:19 PM

Hi guys. Please check the packaged workbook. I have the main datasource (which in the real life is a Tableau Server DS) and the secondary DS (in RL, an Excel).

What i want to accomplish is to show in the view, data from the second DS even though the combination of category and month does not exist in the main one but does in the second one.

I hoped T10 would help me with the new join capabilities but no. And I do not want to make a second DS with all the combinations for all the months or another datasource with the union of both.

Any rock star able to help me?

Thanks!!

PS: its a Tableau 10 workbook.

SAMPLE VOID.twbx 9.8 KB

1. Re: Populate empty cell with data from other datasource.

cor.bader Aug 17, 2016 4:29 PM (in response to gabriela..zorrilla)

It sounds like you need a union join, but I don't believe a published data source can do that yet.

You will likely need to export the data from the published data source into the same excel file (different sheet).

Have you tried appending the data? Are all the fields the same?
Like Show 0 Likes(0)

Actions
2. Re: Populate empty cell with data from other datasource.

gabriela..zorrilla Aug 18, 2016 3:04 PM (in response to cor.bader)

Hi Cor Bader . What you mean with appending the data? So far i created a scaffold datasource with all the category/weeks combinations and managed to partially get this to work but creating another issues (that deserves another topic).

Thanks!
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Populate empty cell with data from other datasource.

1. Re: Populate empty cell with data from other datasource.

2. Re: Populate empty cell with data from other datasource.

Actions

More Like This