Identify the Error by comparing with master data

Question

I am having the orders value which need to get checked with the master dictionary whether the order values are available or not.

If not available, then the exact non-available characters to be shown in the result.

Please refer the excel attachment for more details. Thanks to configure the workflow for the attached worksheet.

Alteryx.xlsx

Rukmanggathan · Answer

Thanks for the Support !!!

In the workflow which you configured the Master Dictionary Column made Text to Column which creates a 20 Records.

But the requirement is that it should check with the combination of those 5 Criteria of Master Dictionary Column.

Example: If first criteria matches, then second criteria to check and then third criteria check. Based on the previous criteria's match the next applicable criteria to be checked.

Please refer the attachment and consider the revised worksheet.

Alteryx.PNG

Alteryx.xlsx

messi007 · Answer

@Rukmanggathan?

Please see beliw how you can do that :

1- Check if columns match

2- Filter not matching data

3- Split column to row

4- Check data that don't match and flag "True/False"

Attached the workflow.

Hope this helps!

Regards,

Check_20220404.yxmd