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/

Row wise Columns Comparison with comluns_gawa.yxmd