1 of 1 people found this helpful
I looked at the data if I understand the individual data sets are 1 week of store level sales - I can't discern the codes but it looks like the sales are at the product store level and results in a wide short table -
Tableau and all other database based systems like lean tall files - so what to do
can Prep help - Yes - you can start by pivoting the individual files around store and product so you have something that looks like a tall data set date - store - product - sales (not certain what else is in the table) You may need to do 2 level pivoting in Prep one for store and a second for product (note you can not do 2 level in Tableau proper - just Prep)
then you can union each of those weekly files together - (I can't tell you if unio then pivot would be better because you noted that the files a more or less the same structure)
That will result in a set that is more efficient
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.
Hi Jim, thx for your insight.
I heard that Prep cannot union more than 10 tables. Should I use Prep everytime as a single flow then manually combine the data into excel?
you heard almost correct - there is a 10 file limit to any one union but then you can take the resulting "unioned files" and union them and so on -