1 of 1 people found this helpful
This is going to tough in Tableau but in Tableau prep it would be easier -
you would be able to join or union after you pivot the first file see the link
if you have some dummy data for the 3 files please attached it and I will give it a try
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.
That is the conclusion I was quickly coming to. I figured I might try a IfNull Statement to get in the general area. I will try to upload a dummy workbook, it is difficult as I work in Healthcare and very difficult to upload anything. Give me some time and I will create one at home and upload it from there.
Also- Tableau Prep is out. I tried asking for it at least to try it out and the response was no- we don't want another tool. Plus we don't want a tool that only you know how to use. I also asked for data to be prepivoted in SQL but they don't understand why I need that. The Director is new to this and she is not understanding the differences in data very well in this case. She doesn't understand the concept of Tall versus Wide, "we have always used Wide in the past".
Right now going to resort to manual in Excel to see what I can do to at least get the data into a usable format for me.
I hear the pain
There are other data shaping tools if you have access to those in lieu of Tableau Prep
Any suggestions? I don't know too many - maybe SAS which we have but I don't know how to program as well with R. Something fairly easy to learn would be great.