Hi, I am trying to convert Power queries from an Excel into an Alteryx workflow, to get the same output than in the original Excel. I am working with large data (think 1 million+) which makes it hard to visualize. What I notice however is that before my unique tool in Alteryx the number of rows is the same as in the Queries, the output straight after the unique tool has a 200k row difference compared to the query version.
I use = Table.Distinct(#"Removed Other Columns", {"Article ID"}) in Power Query
and the unique tool with Article ID selected in Alteryx.
1. Why is there such a difference?
2. How can I make sure I get the same output in Alteryx than in Power Query? E.g. is there a way to embed code that would behave in the same way as in Power Query
Thank you for your help,
PS: I cannot share the workflow.
