excell data validation & error handling with log

Question

Hi All,

Recently i have started working on Alteryx and i have a requirement to work on it.

i have multiple files i have 50 columns and each column has its own validation check to be processed .

for all the 50 columns i need to check the rule  and if it is incorrect i need to notify them stating the error.

what would be the best approach.

ManojSK · Answer

attached the file for your refference

dummy_alteryx.xlsx

chuckleswk · Answer

If you have an example file and what the example checks would be, that would be helpful... It's hard to say beyond that about what would be the best route to take as there can be many different ways to do this!