Hi All,
i have below data how can i compare data and give true-ups. what is the best way to do the comparisons in Alteryx.
when i read article they are using Fuzzy Match. what are the other ways we can compare multiple columns.
| Input | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| Num | EDate | P Date | T Date | S Date | Rate | Cost | S Cost | D Rate | | | | |
| 22931 | 10/4/2022 | 10/6/2022 | 10/04/2022 | 10/06/2022 | 1 | 71000 | -71,000.00 | 1.0 | | | | |
| 100784 | 10/4/2022 | 10/19/2022 | 10/04/2022 | 10/20/2022 | 0.9 | 1139700 | -1,139,700.00 | 0.9 | | | | |
| 39107 | 10/4/2022 | 10/6/2022 | 10/04/2022 | 10/06/2022 | 1 | 3700 | -3,700.00 | 1.0 | | | | |
| 280749 | 10/4/2022 | 10/19/2022 | 10/04/2022 | 10/20/2022 | 0.9 | 125100 | -125,100.00 | 0.9 | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| Expected Output | | | | | | | | | | | | |
| Num | EDate | T Date | Comp | P Date | S Date | Comp | Rate | D Rate | Comp | Cost | S Cost | Comp |
| 22931 | 10/4/2022 | 10/04/2022 | TRUE | 10/6/2022 | 10/06/2022 | TRUE | 1 | 1.0 | TRUE | 71000 | -71,000.00 | TRUE |
| 100784 | 10/4/2022 | 10/04/2022 | TRUE | 10/19/2022 | 10/20/2022 | TRUE | 0.9 | 0.9 | TRUE | 1139700 | -1,139,700.00 | TRUE |
| 39107 | 10/4/2022 | 10/04/2022 | TRUE | 10/6/2022 | 10/06/2022 | TRUE | 1 | 1.0 | TRUE | 3700 | -3,700.00 | TRUE |
| 280749 | 10/4/2022 | 10/04/2022 | TRUE | 10/19/2022 | 10/20/2022 | TRUE | 0.9 | 0.9 | TRUE | 125100 | -125,100.00 | TRUE |
| | | | | | | | | | | | | |
Thanks in Advance,
NR
