The following article from our online help should give you some insight as to why the asterisk is appearing:
Hope this helps!
The frustrating asterisk...
To get your workbook to show your data correctly you will need to use a join to connect the data.
There are a few ways to join your data.
- Import both data sources to a relational database and connect to it then use tableau's multiple tables feature to create the join
- Import both data sources to an excel file (each data set on a separate tab) and create the join like above
- Save the first data set as a CSV file to the same folder as the sos_som.csv file, then make your join.
I am not sure of the format of the first data source since it is currently a data extract (the top one).
Here is a link to join Excel Worksheets: http://kb.tableausoftware.com/articles/knowledgebase/joining-excel-worksheets
You can apply the same method to csv files as long as the data files are in the same folder. You might also want to read how to create a schema.ini file in that same directory (it allows you to define how tableau treats the data as it imports)
Here is an example I use to import data for a dashboard. The column "LocCode3" sometimes starts with 0 (034 for example). If I want Tableau to bring it in as Text (from a CSV file) I add the following to a file named "schema.ini" that is saved to the same folder. You can define more than one source in the schema.ini file (say you have 12 csv files)
Gus, a join isn't always right - it's great if you want to append an address to a location for example. But it won't work in many situations - for example sales data and hours worked data where the only linking field is a datetime and the same datetimes do not exist in both. You cannot use a join on this.
Equally, without care on how you use the joins you can end up with a number of rows that is the cross-product of the matching rows/field.
It's very difficult to say what will happen with Samanta's data without seeing the datasets, but looking at the fields I suspect a join would cause problems. It could be that some custom SQL would solve the issues, but a straightforward join probably isn't the solution.
You bring up a good point... without the datasets it is difficult to say what exactly would work.
Hi all i attached the files and the workbook
i would apreciate if you can have a look
thanks for the reply
what if i want to show the multiple matching members ?
instead of the asterisct the hole list with matching member its possible ?
I'm guessing this is not the data that you're working with. However, one possible option would be to use source2 as your primary source and source1 as the secondary.
You provided two CSV files in your ZIP file... One with the original structure and the other that was pivoted using the Tableau Excel Add-in...
Did you mean to add a second data set?