UNION TOOL .my union is always doing union all .

[dikshit_luthra]

Just want to clarify , suppose I have 2 inputs with same file and only 1 row with same columns.. and doing union is giving 2 identical rows but supposed to give only 1 . Why is it so ?

[apathetichell]

union adds records. If you have one row in one source and one row in another source - you will have two rows. You may want a join tool.

[atcodedog05]

Hi @dikshit_luthra 

By default union tool will always show all columns. If you set config like below it will only show common columns between dataset.

Hope this helps : )

[SoccerTil · Accepted solution]

The Alteryx Union widget is a SQL Union All. In the database SQL language the Union returns only unique records.To accomplish this the Query Engine will remove duplicates after the two sources are blended. You can do the same. Union then Unique.

[apathetichell]

@SoccerTil's point is excellent - I'd add that Unique takes the FIRST unique value. If you want a different one - you can change order (in the union tool) of which datasource is first.

[SoccerTil]

That is true. Also a great feature of Alteryx that you can exploit in many different scenerios. 

[dikshit_luthra]

Yes, I guess it does union all. After union , doing unique worked.

[dikshit_luthra]

Yes, I too changed config to same, but it is union all and not union. So Unique has to be done. 

[dikshit_luthra]

CAN ANYONE HERE, HELP IN SERVER UPGRADE , LIKE do-to list before and after upgrade. 

?///??

I have read alteryx documentation but If someone already did, will be helpful .