IM new to Tableau and I wanted to ask about approaching a unique problem. I want to use Tableau to analyze the contents of a several flatfiles independently. What I mean is that I have several flat files all structure in the same fashion. I would like to apply a predetermined set of analysis to the contents of each of these files but I would like to be able to view the resultant reports separately. I would also like ot be able to add new files and quickly present the same reports for these files.
What is the best approach here. Load the files into separate tables in a database? Combine them into a single database but attaché some kind of identifier to each files rows? connect directly with the flatfiles(if possible)