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.