Hi there, just start to use Tableau
I have configured Tableau to pull an extract from 2 txt files join together with this sql statements below and work fine .
SELECT *
FROM [2010combined#txt]
UNION ALL
SELECT *
FROM [2011combined#txt]
Now I tried with one more file (CALENDARIO.TXT), But didn't work with Union All and Inner Join together, see statement below, so how can I do that in Tableau
SELECT *
FROM [2010combined#txt]
INNER JOIN [CALENDARIO#txt]
ON [CALENDARIO#txt].[DATA1] = [2010combined#txt].[DATA_FATURADO]
UNION ALL
SELECT *
FROM [2011combined#txt]
INNER JOIN [CALENDARIO#txt]
ON [CALENDARIO#txt].[DATA1] = [2011combined#txt].[DATE_FATURADO]
Thank you in advance
Hi Richard, thank you for your answer.
I realize that my syntax has a error on the second INNER JOIN should be [2011combined#txt].[DATA_FATURADO] instead, work fine now.
Richard could you please tell me what is the best way to try join.
I really don't know what you mean when you say to try one pair of tables without the UNION ALL.
