DataTable Columnal Search


I have an automation Question

This is my current view

For each AccountID, I need to download a document for every month. There are some Accounts that have already downloaded the document, and some which didn’t. The account’s that have downloaded the document will populate the row for which month they have downloaded based on the AccountID and populate it with a string = “D”

My issue is :
If I want Studio to provide me with the information that for AccountID - 34512 , I need to extract which months that do not have the letter D before the run month (April 2021). How can I do it?

Thank you in advance.

Hope anyone can help me :slight_smile:

1 Like

can you write what you have already done?
I would not like to write you the obvious like: do it in a for each row loop