Please add a dummy column called flag,column flag will be added in all the sources you have and the values (data) in the flag column will have unique values to identify each country.
using the flag column you can join or blend data and latter identify the data based on the flag values.
hope it helps.
Hi Bharat, and thanks for your quick answer!
But I didn't find how to create the dummy column.
I tried with the next expression for set up the custom field:
IF [Data Source] = "Account 1" THEN "Country 1" ELSE "Country 2" END
But no results
Could you give more details to achieve this?
By dummy column i mean adding a new field at database or datasource level.if excel is a source then add a new column in excel sheet.
if multiple excels are there then add the new column in all the excels.
hope that clarifies.
Hi Bharat, and thanks again!
I understood your explanation but my datasource is not an Excel, are several accounts of Google Analytics.
And I would like to add a field to identify each data source once I had combined all the data.
If your source is google analytics then You can get the source name by inserting datasource field into tableau.
once you get the source name you can create a calculated field and built a logic to meet your requirement.
hope that helps.