Highlight differences in the Output (data stocked vertically)

Question

Hi,

is there an option to highlight data in the Output when the data is among each other? I tried something like [Row]!=[Row+1], but this is not possible. I have a very big data set with 6000 rows and 53 columns, therefore I would need a more generic solution.

like:

value1value2FileNameABFile1ACFile2sdfkjhdfkKFile1dsfasdfdsfKFile2

Thanks for your help!

BR

Teresa

Teresa3 · Answer

@binu_acs ok, get it. Thank you. But I will not use this solution. I have a big dataset with 53 columns. Therefore I would need a more generic solution which can be applied over lot of columns.

I guess this is a functionality which is missing in alteryx atm.

binu_acs · Answer

@Teresa3 I was giving you a sample workflow for reference, you can setup a flag value using a multirow tool based on your requirement

Teresa3 · Answer

Hey @binu_acs ,

thanks for your answer. This seems not so good for highlighting differences. As you can see the value A of value1 (File 2) is already highlighted, despite it is the same like in File 1. Therefore it would highlight the false value.