how to perform minus using Alteryx

[kirangottu]

Pls tell me How to perform MINUS using Altreyx tool...

I am a ETL tester,this function is very much needed...Currently I am doing join and comparing every column whcih is little bit tideous job. I want all the source and target columns shold be compared in a one go like MINUS .....Plsss help me....

[MarqueeCrew · Accepted solution]

@kirangottu,

I reviewed a Minus Query definition at:  http://www.querysurge.com/solutions/minus-queries

A Minus Query is a query that uses the MINUS operator in SQL to subtract one result set from another result set to evaluate the result set difference. If there is no difference, there is no remaining result set. If there is a difference, the resulting rows will be displayed.

Here is a solution for finding the rows that are unique to table1 and unique to table 2.

Hopefully this helps solve your needs or gets you much closer.

Cheers,

Mark

[kirangottu]

Thank you ....very much helpfull...

[MarqueeCrew · Accepted solution]

@kirangottu,

I have submitted a macro that creates a Minus Query for inclusion into a future release of the CReW macro pack.  I am posting the submission here for your use.  Should you find that the macro works for you, please do mark this as solved.  Otherwise, please provide your feedback.

If you save the file into your:  C:\Program Files\Alteryx\bin\RuntimeData\Macros directory (may differ on your machine), the macro will be easily accessible to you.

Cheers,

Mark

[DeepthiYadav]

@kirangottu,

Hi I am datawarehouse tester from Bangalore, have experience in etl testing using informatica. The workflows between stages tested using SQL queries.

I would like to know how the testing is done for alteryx workflows, please suggest.

[kirangottu]

u can reachout to me on 7259367421

[erase_ego]

Hi @MarqueeCrew,

I was just wondering why a simple join on all columns would not suffice?  For example,  for the datasets wouldn't L & R of a join  return the result of minus operation? If we name these as Table_1 and Table_2 wouldn't L contain Table_1 - Table_2 and R contain Table_2 - Table_1?

Specifically, wouldn't the following give the same results as given by your workflow?

[MarqueeCrew]

Interesting point. I have played with this for multiple purposes including identifying the columns with differing values along with the capability to exclude columns from comparison.