Updating multiple rows of multiple columns

[QurrathAmeena]

Hi ,

I have recently started working with real-time problems using Alteryx.

I'm facing some challenges in updating multiple rows and highlighting them in the output .

I'm briefing the problem statement and expected output here:

I have an original file where I have to make changes comparing the "ID" and "POSITION" column in the updated files.
Also ,I want to highlight(color) the updated columns in the original file.

Given below are the original and updated files :
Original file

ID	COL1	COL2	COL 3
1	AA	BA	CA
2	AB	BB	CB
3	AC	BC	CC
4	AD	BD	CD
5	AE	BE	CE
6	AF	BF	CF
7	AG	BG	CG
8	AH	BH	CH
9	AI	BI	CI
10	AK	BK	CJ

Updated files:

ID	POSITION	ORIGINAL VALUE	UPDATED VALUE
3	COL1	AC	ACC
8	COL2	BH	BHH
10	COL 3	CJ	CJJ

ID	POSITION	ORIGINAL VALUE	UPDATED VALUE
1	COL 3	CA	CAA
7	COL1	AG	AGG
9	COL2	BI	BII
10	COL 3	CJ	CJJ

OUTPUT:

If the output is updated more than ones it must be highlighted as 2x,3x respectively.

Thanks in Advance 🙂

[Qiu · Accepted solution]

@QurrathAmeena 

Quite interesting topic.😁

[QurrathAmeena]

Thanks a lot @Qiu 

Also,How did I report the output by highlighting the rows.

Should I use table tool?

[Qiu]

@QurrathAmeena 
Glad to help and thank you for the accept mark.

Yes, I can think of Table tool with Row or Column Rules.