topic Not sure about how Union is working?.. real case mistery in Alteryx Designer Cloud Discussions

Not sure about how Union is working?.. real case mistery

TrifactaUsers — Thu, 21 Nov 2019 10:41:09 GMT

Hi have one dataset with 83k rows and the other with 32K. first dataset columns "name" "correct name" second dataset "nameds" and "correct name" no duplicates in each one. I execute Union and the result is just 82K rows. ( so lees them intial)

I understand union as a below all data add is it correct?

thanks

Re: Not sure about how Union is working?.. real case mistery

Trifacta_Alumni — Thu, 21 Nov 2019 13:14:30 GMT

Hi @juan sánchez? That's because whatever you see on browser is a sample aka Representative set of rows from the raw dataset. Take a Quick scan random sample after the Union and you will find random rows appear from both datasets. Definitely worth a read would be this documentation on Sampling https://docs.trifacta.com/display/SS/Overview+of+Sampling.

Best

Vardan

Re: Not sure about how Union is working?.. real case mistery

TrifactaUsers — Tue, 03 Dec 2019 16:05:06 GMT

thanks a lot Vardan ;)