This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My data shows something like this below., I need to remove the whole row, it is duplicate and keep the whole row if the site/SKU combination is unique. In my first comment, I think I did not make it clear.
So, do you recommend this Unique tool or only unique function in this case. Thanks a lot
With the sample data it's a little too hard to work out what's gone wrong.
But I still think it is the join multiples that are here in the "ABC_logic" container:
I'd recommend replicating that container using normal join tools as you will be able to track what's joining, what's not much easier.
As mentioned the join multiple doesn't behave like a join and union. So if you have unjoined fields, they end up in the output with blanks in fields with the same name but they get prefixed "Input_#2_" for example.