I would like to see the TWBX file on this with the data - don't really have a dataset that is similar
But when you created the Union there should have been 2 dimensions added to the data "Table name" and Sheet"
the dimensions point to the files and sheet in the file you used in the Union - you can use them like any other dimension in formulas or filters
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.
Thanks for the swift response.
In the union i'd specified a sheet name so that is the same for all xls files. There is no table dimension, only a path which gives the directory and filename. I'm using that the split the data into columns as each one is unique as it ends with yyyymmdd.
My issue is that I can't filter on path for month 1 AND the feature on/off value whilst retaining month 10 and its feature value.
I've been looking at using a parameter but can't get my head around whats needed.
Did the view include a dimension "Sheet" and another dimension Table Name - those are Tableau generated - if you use the same name in your files Tableau will append an sequential integer to each like Sheet, Sheet1, Sheet2 etc
Open the dimension and see what is there
In the union I used a wildcard only for the file name, then specified the same sheet name from each of these files. All the sheet names are therefore the same (in the sheet dimension)
There is defnitely no Table dimension generated, only the path (which I'm using as column headings)
well you know what you are seeing
If you post I Twbx workbook I will see if there is another way to meet the need
Its a tricky one as its full of commercial data (and 30megs)