Row wise Columns Comparison with comluns

[KamalChoudhary_in]

Hi All,

I am trying to lookup row wise values from comlun 5,6,7 with 1,2,3,4, or more if exists and highlight the non match values 

Note for words in parenthesis "()" , we can disraged for the seacrh match e.g  London(PC) we will lake London for lookup and (PC) is ignored 

inputDate 

1	2	3	4	5	6	7
Center	LOB	Location	Level	Area	Makret	Region
ASIA HK	Taiwan (DC)	India (PC)	London (DC)		Asia China(PC)	London(PC)
Asia China (DC)		Taiwan (PC)	London (DC)		Taiwan (PC) ,London (DC)	China (PC)

Deisred output we can change text colur or highlight non matching values Asia China and China 

1	2	3	4	5	6	7
Center	LOB	Location	Level	Area	Makret	Region
ASIA HK	Taiwan (DC)	India (PC)	London (DC)		Asia China(PC)	London(PC)
Asia China (DC)		Taiwan (PC)	London (DC)		Taiwan (PC) ,London (DC)	China (PC)

[gawa]

@KamalChoudhary_in 

Very tough challenge, but I managed it somehow. First step is to transpose data in to vertical shape, and parse data, then compare correspondence by join tool, and find unmatched cell. After that, by creating dummy columns for all columns and put "False

" at unmatched cells. After all of this, in table configuration, set text color, and finished.

Please note that more data parse process would be needed depending on your real data. Just for reference, I attach my workflow/

[KamalChoudhary_in]

Hi @gawa ,

Thanks a lot for you help, what if we have additional text available in the column and you want to color only text which is not matching

We want to keep red text along with match values in black like   Taiwan (DC) and London (DC) are add along with red text 

inputDate 

1	2	3	4	5	6	7
Center	LOB	Location	Level	Area	Makret	Region
ASIA HK	Taiwan (DC)	India (PC)	London (DC)		Asia China(PC),Japan	London(PC)
Asia China (DC)		Taiwan (PC)	London (DC)		Taiwan (PC) ,London (DC)	China (PC)

Deisred output we can change text colur or highlight non matching values Asia China and China 

1	2	3	4	5	6	7
Center	LOB	Location	Level	Area	Makret	Region
ASIA HK	Taiwan (DC)	India (PC)	London (DC)		Asia China(PC) , Taiwan (DC)	London(PC)
Asia China (DC)		Taiwan (PC)	London (DC)		Taiwan (PC) ,London (DC)	China (PC), London (DC)