I need to refine a DataTableA, but I need to change the target items dynamically depending on the settings in an external file.
Group by A having B > 100
Group by D having A < 20
As you can see, depending on the condition, the Select item and the search condition also change.
Therefore, the Filter Data Table activity, which has fixed values, will not work.
I’m wondering if there is a way to change the code statement of the String variable to a SQL statement as shown above, and get the filtered DataTable.