Highlight differences in the Output (data stocked vertically)

[Teresa3]

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: 

value1	value2	FileName
A	B	File1
A	C	File2
sdfkjhdfk	K	File1
dsfasdfdsf	K	File2

Thanks for your help!

BR

Teresa

[binu_acs]

@Teresa3 One way of doing this is with the Table tool. In the Table tool you can define the column rules and rows rules based on the data.

Attaching a sample workflow

[Teresa3]

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.

[binu_acs]

@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]

@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.