4 Replies Latest reply on Mar 5, 2017 6:13 PM by siyu liu

    How to compare the difference between 2 files in Tableau

    siyu liu

      Hi all. On a monthly basis I will receive a batch report and we need to compare the TXT output of these files with last month data. The comparison should send a notification that whether anything has been changed between the table output for this month with last month. It's a little urgent, could you kindly help? and if you need more information, please advise. Thanks in advance for your help.

        • 1. Re: How to compare the difference between 2 files in Tableau
          Deepak Rai

          Create a new calculation:

           

          IF ATTR [last month data]=ATTR[this month data]

          Then "Yes"

          ELSE

          "NO"

          END

           

          Wherever there will be change it would say NO,

          See attached.

          Thanks

          Deepak

          • 2. Re: How to compare the difference between 2 files in Tableau
            siyu liu

            Hi Deepak, thanks for your help. Actually the TXT file include several columns and I want to compare values of each column. Attached the data as below:

             

            Client|Sales Org|Distr. Channel|PL/Division|Cust.Stats.Grp|Matl stats grp|Doc.stats.group|ItmCatStatGroup|Update group

            100   |         |              |           |1             |1             |1              |1              |1          

            100   |         |              |           |1             |1             |2              |2              |2          

            100   |         |              |           |1             |2             |1              |1              |1          

            100   |         |              |           |1             |2             |2              |2              |2          

            100   |         |              |           |1             |3             |1              |1              |1          

            100   |         |              |           |1             |3             |2              |2              |2   

             

            And do I need to combine these 2 database in Tableau? Thanks!

             

            Sylvia   

            • 3. Re: How to compare the difference between 2 files in Tableau
              Deepak Rai

              hi Siyu,

              Can you attach few rows from both txt files separately here.

              Thanks

              Deepak

              • 4. Re: How to compare the difference between 2 files in Tableau
                siyu liu

                Hi Deepak,

                 

                Attached are two output files of different dates. Thanks in advance!

                 

                Best regards,

                Sylvia