Hi @adrian1713!
@ChrisTX's article suggestions are excellent. I wanted to chime in to address your question regarding how you can create a table with highlighted cells.
The trick here is to build your logic so that each row has a highlight flag for each ID. You can do this with the formula tool based on whatever logic applies to your use case. In this example, I used "if [ID A] != [Right_ID A] then "Y" else "N" endif" for the updated records and "Y" for any new or removed records. You may need to adjust the logic based on your use case.
Within the Table tool, you can use the "Column Rules" to apply the highlighting logic to each column. The highlight fields can then be unselected as they are not needed in the final table. You can also apply any other formatting to make the table look as desired.
Here's an example configuration:
Note that the columns names in bold have specific rules applied. These rules must be added one-by-one for each column.
Output:
Let us know if this helps.
Thanks,
Deb
There are so many ways to do things in Alteryx! @ChrisTX's solution will work. An alternate approach would be to add a filter tool after your join. Here's how that would be configured:
The formula in the custom filter would look something like this:
[ID A Highlight]="Y" or [ID B Highlight]="Y" or [ID C Highlight]="Y"
Hope this helps,
Deb
