Hey team!
I know we all have had problems working on data tables (especially filter) in AA. My use case looks pretty simple but while working on it I am facing challenges. Please suggest on how to go about the problem I am facing
Agenda: I have a data table assuming 50 rows and 30 columns (the columns are fixed and the rows vary each run. The extract is run each day), I need to write those values into google sheets based on a date value which is in string. Example - I have a base data table named DTBaseTable which has 50 rows and 30 columns. ‘Joining Date’ is one of the column name on which we need to create sheets. A person has a joining date on 2025-04-07 (YYYY-mm-DD) which needs to be on the 2025-04-07 sheet and another person has 2025-04-14 joining date which needs to be on its own sheet named 2025-04-14. There are 30 column values which also needs to be added on to the respective sheet.
My Current State: I have the base data table in a data table variable. I have all the unique joining dates in a list variable, all the existing sheet names in another list variable and currently the bot is creating sheets (based on joining date) if not already present.
Problem: While looping my base data table; DTBaseTable which has all the values - I am facing a challenge on how to write back the values to its respective sheet based on the joining date. I cannot create data tables dynamically.
I do not want to use ‘set cell’ which has caused API quota limit issues and that is the last resort which I want to take.
Please comment your opinion/solution. TIA!
