Skip to Content
Author's profile photo Puneet Pokharna

Comparation of Query Properties with WinMerge and RSRTQ transaction.

Steps to make the comparison of the changes in a query:

1)   1)   Run the transaction RSRTQ and choose a query, for example: Z_FI_MPCA2_016.Select all

2)   2)   Checkbox and run.

P1.png

sd   3)    Need to press Export button as mentioned below:

fs        /wp-content/uploads/2013/12/p2_341231.png

            4) Information popup comes then press OK.

               /wp-content/uploads/2013/12/p5_341239.png

          5)   Downloaded the file in Excel Format:

           /wp-content/uploads/2013/12/p4_341237.png

              /wp-content/uploads/2013/12/p6_341252.png

                 /wp-content/uploads/2013/12/p7_341253.png     

         5) Open the Excel file y and we save in CSV format (coma delimited).               /wp-content/uploads/2013/12/p8_341254.png

        6) Lets take example : make the change in the query, in this case doing Always Show column “Cost to Serve per Hour to HIDE.          

   

               Pre Changes on Query : –>

                 /wp-content/uploads/2013/12/p9_341255.png

                       After Changes on Query:–>

               /wp-content/uploads/2013/12/p10_341256.png

   

       7)  install WinMerge v 2.14, if it’s not have install.

      http://winmerge.org/downloads/

8) Open the WinMerge Program, and select the menú File–>Open.

2)  

      9) Press Browse button to select the two newly csv files generated

          /wp-content/uploads/2013/12/p11_341257.png

        10) Press OK  and obtain the result of the comparison.

              /wp-content/uploads/2013/12/p12_341258.png

              This figure shows the change to hide the column Cost to Serve per Hour that was detected by the WinMerge program.

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Laurant Dsouza
      Laurant Dsouza

      Hi Puneet,

      Nice document for comparing between 2 queries, very helpful when changes have to be found between the two.

      Regards

      Laurant Dsouza

      Author's profile photo Former Member
      Former Member

      NIce one Puneet...  🙂

      Author's profile photo Former Member
      Former Member

      Nice doc..

      Regards

      Poorna

      Author's profile photo Former Member
      Former Member

      good pictorial represenation

      Author's profile photo Former Member
      Former Member

      Nice doc ...you can also use "compareit " tool to replace winmerge .

      Author's profile photo Former Member
      Former Member

      Great document to have comparison.

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Good one.

      Author's profile photo Former Member
      Former Member

      Thank you, very helpful document.

      Best Regards,

      Venu Gopal

      Author's profile photo Former Member
      Former Member

      Nice doc ...