topic Re: Filtering out similar data from 2 different column in Alteryx Designer Desktop Discussions

Filtering out similar data from 2 different column

Glenlim — Wed, 17 Jan 2024 11:11:18 GMT

Hi,

Can anyone help me with this issue below?

I have been trying to filter out similar data from 2 different columns (below). I've tried using the Unique tool but it's not pulling out any similar data.

I've also tried using the Formula tool but doesn't work either.

Re: Filtering out similar data from 2 different column

kamal03 — Wed, 17 Jan 2024 11:26:34 GMT

Is it possible for you to share sample dataset ?

Re: Filtering out similar data from 2 different column

Peachyco — Wed, 17 Jan 2024 11:27:24 GMT

Are you trying to find the values that exist in both columns, regardless of whether or not they actually exist in the same row? Something like this can work:

It starts like this:

And ends up like this:

Re: Filtering out similar data from 2 different column

Glenlim — Wed, 17 Jan 2024 11:55:55 GMT

Hi,

please find attached the sample data.

Thanks

Re: Filtering out similar data from 2 different column

Glenlim — Wed, 17 Jan 2024 11:56:51 GMT

Tried your method but doesn't seem to be giving me anything in the join output.

Re: Filtering out similar data from 2 different column

Deano478 — Wed, 17 Jan 2024 12:32:13 GMT

Hey @Glenlim can you define what you mean by similar in this context?

Re: Filtering out similar data from 2 different column

Glenlim — Wed, 17 Jan 2024 12:33:42 GMT

Apologise if I am not clear enough.

I want to find out which data from Thinkfolio column appears in the Trade data column.

Re: Filtering out similar data from 2 different column

Deano478 — Wed, 17 Jan 2024 12:43:02 GMT

@Glenlim You can try something simple like this to see what is common in both:

Re: Filtering out similar data from 2 different column

Glenlim — Wed, 17 Jan 2024 12:54:26 GMT

Hi,

do you mind posting as a photo as I am not able to download it.

Thanks

Re: Filtering out similar data from 2 different column

grazitti_sapna — Thu, 18 Jan 2024 05:29:50 GMT

Hi@Glenlim
One simple approach to address this issue involves utilizing the join tool. If the data includes redundancies, consider removing duplicates before applying the join. Please find the solution below, which covers both scenarios — with duplicates and without.

If it works Kindly accept it as Solution.

Thanks