1 of 1 people found this helpful
If you are trying to import a number of Excel files .Each one of those files may contain data about one table. Some of them are primary tables but some of them are secondary/lookup tables containing category descriptions, school names, etc.. you told that you 15 such tables. Right now, in Tableau, If you have to import them one by one and then use data blending to create the relationships between them. if you want to do is to import all of these files under a single connection and list them as they are coming from the source . and then create the relationships in advance of creating any visualization.
One hack that I have found is to combine all the above Excelsheets into one Excelsheet and then import that as a datasource - in that case, I am able to see them as one source and define joins in advance. But this involves more manual work for each time the data is refreshed.
Thanks for the reply Tharashasank Davuluru
I am trying to stay away from more manual work, but this might be the best solution at this point. I didn't quite understand your explanation on the first paragraph, I appreciate if you can elaborate some more.