Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter out specific values from same column name in two different files

Chirag_Gandhi07
8 - Asteroid

Hi All,

 

I have two data files with one common column. I sort both of those columns in ascending order. In one file, I need to take the last value for that column and basically match that with the value from the other file. I then need to take the values below the value that matched and filter them out. So below is an example:

 

Column A (File 1)                   Column A (File 2)

Abc123                                     Abc123

Def350                                     Def350

Def350                                     Def350

234Bhg                                    Jkl456

                                                DHY532 

                                                234Bhg

                                                Jiu782

                                                Dea451

 

So what I would like to happen is that it looks at the last value from column A (File 1) which is 234Bhg and compares that to Column A (File 2) and filters out all the values below 234Bhg from Column A (File 2). In this case, the values that would be filtered out would be Jiu782 and Dea451.

 

Any and all help is greatly appreciated. Thanks!

3 REPLIES 3
Simha
9 - Comet

Hi,

 

Here's a solution to your problem. Don't forget to accept the solution, if it works for you 🙂

 

Regards

Simha

Simha_0-1583264244744.png

 

Chirag_Gandhi07
8 - Asteroid

Thank you! @Simha 

Simha
9 - Comet

You are welcome @Chirag_Gandhi07. Glad I could be of help.

Labels