topic Re: How to search by cell value and arrange on alteryx in Alteryx Designer Desktop Discussions

How to search by cell value and arrange on alteryx

hegdepavithra10 — Fri, 16 Oct 2020 10:52:20 GMT

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?

Re: How to search by cell value and arrange on alteryx

atcodedog05 — Fri, 16 Oct 2020 11:01:01 GMT

Hi @hegdepavithra10

Are the input files always in the same format ?

Where 3rd and 4th row have the info to be transformed.

Re: How to search by cell value and arrange on alteryx

radha_ashok — Fri, 16 Oct 2020 12:11:20 GMT

Hi, Can you pls provide the sample files to work on this

Re: How to search by cell value and arrange on alteryx

TheOC — Fri, 16 Oct 2020 11:06:21 GMT

hi @hegdepavithra10

This is definitely achievable, as @atcodedog05 said however, I am curious as to whether these are always in the same position. Can you please upload the excel spreadsheet that you screenshot above, and i'll be more than happy to take a look at this for you!

Cheers,
Owen

Re: How to search by cell value and arrange on alteryx

hegdepavithra10 — Fri, 16 Oct 2020 11:44:31 GMT

Yes. They are always in the same format.

Re: How to search by cell value and arrange on alteryx

hegdepavithra10 — Fri, 16 Oct 2020 12:02:06 GMT

Here are the files. The snippet i attached is from the file named as "Alteryx sample(i). So this is the use case. There are multiple Alteryx sample files. They are based on the type value in file "Alteryx main file".

(i)I need to compare the numerical values under the bold attributes in both the files.

(ii)The bold attribute names in both the files are not exactly same.

Re: How to search by cell value and arrange on alteryx

atcodedog05 — Fri, 16 Oct 2020 12:03:22 GMT

Hi @hegdepavithra10

That's great info. Can you provide some sample files and expected output. So that we can stream line our workflow according to the requirement.

Edit : great you just shared 🙂

Thanks

Re: How to search by cell value and arrange on alteryx

hegdepavithra10 — Fri, 16 Oct 2020 12:05:21 GMT

The sample files will be in the same format, they wont change.Just the numerical values will change. So a generic workflow for the files i have provided would suffice for the rest.

Re: How to search by cell value and arrange on alteryx

TheOC — Fri, 16 Oct 2020 12:11:42 GMT

hi @hegdepavithra10

I have achieved a workflow that received the output you were hoping for:

I'm sure @atcodedog05 knows a way of making it much more concise and elegant, but this works with your excel sheet provided!

Re: How to search by cell value and arrange on alteryx

atcodedog05 — Fri, 16 Oct 2020 12:38:44 GMT

Hi @hegdepavithra10

Here is a workflow for the task.

Output:

Workflow:

Hope this helps 🙂 and what you are looking for.

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

Re: How to search by cell value and arrange on alteryx

TheOC — Fri, 16 Oct 2020 12:39:48 GMT

@atcodedog05 I was right! Nice workflow 🙂

Re: How to search by cell value and arrange on alteryx

atcodedog05 — Fri, 16 Oct 2020 12:46:53 GMT

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 🙂

Re: How to search by cell value and arrange on alteryx

TheOC — Fri, 16 Oct 2020 12:48:29 GMT

@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

Re: How to search by cell value and arrange on alteryx

hegdepavithra10 — Fri, 16 Oct 2020 14:17:28 GMT

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.

Re: How to search by cell value and arrange on alteryx

atcodedog05 — Fri, 16 Oct 2020 17:09:22 GMT

Happy to help 🙂 @hegdepavithra10

Cheers and Happy Analysing 😀

Re: How to search by cell value and arrange on alteryx

atcodedog05 — Fri, 16 Oct 2020 17:15:23 GMT

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