Enter comments in new column in output

[rachana19]

Hi,

I am looking for a way to add 'Comments' column in the output sheet and enter the comments whenever some column data is missing.

Thanks

[TomWelgemoed]

Hi,

Can you give me an example of your scenario?

Thanks,

Tom

[rachana19]

Thanks for your reply.

Here is the example - 

Input: 

ID	First Name	Middle Name	Last Name
1	Jon	NA	Doe
2	NA	NA	Steele

Output:

ID	First Name	Middle Name	Last Name	Comments
1	Jon	NA	Doe	'Middle Name' is missing
2	NA	NA	Steele	'First Name' and 'Middle Name' are missing

[Jonathan-Sherman · Accepted solution]

Hi @rachana19,

I think this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[TomWelgemoed · Accepted solution]

Hi @rachana19 ,

I've taken the liberty to do another version of this - I tried to use as few tools as possible. I've also added a "Total Fields missing" column, as I think that may be useful. Finally, I tested this with a scenario where all values are populated and added a "All fields present" in such a scenario. Please see an image below and the attached workflow package.

Hope this is of use to you.

Best,

Tom

[rachana19]

Hi Tom,

Thanks a lot for sharing the most efficient solution.

It worked perfectly for my case. Cheers!

[rachana19]

Hi Jonathan,

Thanks a lot for sharing the solution over here.

It works fine.