Alteryx Identifying Highlighted Rows in Input Tool

Hello. I am looking to see if it is possible for Alteryx to recognize highlighted rows in the input file. In the example below, it would be helpful if I could make a note in a different column for the rows that were highlighted.

I know that Alteryx does not easily identify highlighted rows, but was wondering if there could be a workaround for this.

Workflow

Accepted answers

All comments

Jonathan-Sherman

Hi @cpearse,

Thinking aloud I don't *believe* there's a way to determine if they were highlighted manually, if it's done by a conditional formatting formula then you could simply build that into the workflow.

Always happy to be proved wrong...!

Kind regards,

Jonathan

TheOC

hey @cpearse and @Jonathan-Sherman

I believe this may be possible by bringing the xlsx sheet into Alteryx as an Zipped file, to be able to access the XML surrounding it. I have done something similar before (documented here https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Hi-everyone-Please-help-with-the-attached-problem/m-p/758504/highlight/true#M182914) and massively credit @danilang for his genius behind this.

I will give this a test shortly, and let you know if this works for this use-case, however it does bring through information about the cell, such as the formula behind the value as shown in the example.

Hope this helps!
TheOC

TheOC

I have followed this logic with the following excel spreadsheet:

And it grants the following XML:

I believe the " s="1" " part to signify that is highlighted. However this may need more experimentation.
Using that as a test however, and bringing in the dataset normally and joining it:

I have attached this as a workflow, if you want to give it a test for yourself. However, if you supply a different workflow, bare in mind that it will reset all settings in the configuration window. Take a screenshot of the configuration, so you know what to change it to, when adding a new workflow:

XML read document.yxzp

atcodedog05

Once again @danilang saves another day and amazes us with the power of XML 😎

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703