4 Replies Latest reply on Apr 22, 2011 6:56 PM by Juracy Americo

    Query txt file - Use UNION ALL and INNER JOIN in tableau

    Juracy Americo

      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