topic Check presence of specific columns before proceeding in Alteryx Server Discussions

Check presence of specific columns before proceeding

ansonwun — Thu, 07 Jul 2022 03:35:10 GMT

Hi, I have an analytics app that requires users to upload a file with specific column names. For example, if the incoming file does not have the column names "ID" and "Desc" present, the workflow should terminate with a specific error message.

I tried using the Error Message tool on the File Browse tool but can't seem to find a way to check for field names. I also tried the Test tool but the workflow will run regardless of the check, and the error message cannot be customized.

Any pointers will be appreciated. Thanks!

Re: Check presence of specific columns before proceeding

Amol_Telore — Thu, 07 Jul 2022 13:56:06 GMT

I have tested this solution for two fields ID and DESC. If file do not contain any one or both the fields it will show an error message to user indicating "Insufficient data to proceed". You can customize this options as per your need. Let me know if this solves your issus.

Error Message :-

Re: Check presence of specific columns before proceeding

ansonwun — Fri, 08 Jul 2022 01:25:27 GMT

Thanks @Amol_Telore

I've since then arrived at a very similar solution indeed. In addition I've selected the "Cancel running workflow on error" in the workflow runtime configuration just to play safe.

Everything goes as expected. But if I have to be picky: when I run it on the server, it will show something like this:

Just wondering if it's possible to remove that (Tool Id: 277) string, as well as the last line "Workflow was Cancelled by Properties Setting"?

Thanks again.

Re: Check presence of specific columns before proceeding

Gerardo19041999 — Fri, 23 Aug 2024 16:29:35 GMT

Hi!

May I know what was your solution?

I'm encountering something similar here.

Greetings.