How to search by cell value and arrange on alteryx

[hegdepavithra10]

Lets consider the snippet above. The requirement is that the attributes in bold must be imported on to alteryx with their corresponding values next to them on to alteryx so that they can be compared to the same columns from another file.

I am having trouble in importing these values or aligning them in some way so that i can compare with the other file.

is there any way to achieve the below?

[TheOC]

@atcodedog05 I was right! Nice workflow 🙂

[atcodedog05]

Hi @TheOC 

Just a pointer. Data cleaning tool has a new feature added which will remove empty columns/rows.

Saw your Crew macro. Hence thought of telling you 🙂

[TheOC]

@atcodedog05 oh wow! Cant believe I had missed that, is that just in the newest version of Alteryx or have I missed that in the last one too?!

Cheers for that! Great pointer

[hegdepavithra10]

atcodedog05 ,i have one question in this workflow. What is the option used after input?I am using Alteryx Designer 2019.4 version. I am not able to find it.

[atcodedog05]

Happy to help 🙂 @hegdepavithra10 

Cheers and Happy Analysing 😀

[atcodedog05]

Hi @hegdepavithra10 

Sorry i didnt a notification of your post.

Its a Select record tool used select rows based on row position. Try searching in your search bar toward the right Top corner. You should be able to find it.

https://help.alteryx.com/current/designer/select-records-tool