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 🙂
