I have multiple table that are open and need to assign variable based on a contain(DC1,DC2,DC3) of the table name. If table name contain DC1 assign dt1, if it Table name contain DC2 assign dt2....
Table 1: ABC_25C_DC1_2024
Table 2: ABC_25C_DC2_2024
Table 3: ABC_25C_DC3_2024
Here is the command line that i was try to work with.
tablelist = Get Data Table List() << get name;
If(Contains(Concat Items(tablelist), "DC1"),
dt2= XXXXXXXXX
);