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
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
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
Can you give me an example of your scenario?
Thanks,
Thanks for your reply.
Here is the example -
Input:
Output:
