Hi,

I have a large number of tables in a worksheet (19 for now). I have created several scenarios and want, for each scenario, to copy the content for each of the tables and store the values in output variants.
I have defined the output variants as public variants and have created two functions for looping through each of the variants (see below).

Input (correspond to named ranges in the worksheet)
Please Login or Register  to view this content.
Output variants (public variants / dimensions have been set in a separate procedure)
Please Login or Register  to view this content.

I have created a procedure to loop through each of the input variants and store the content in the corresponding output variants (see below). Note that this procedure will be called from the procedure containing the scenarios. I would like to retrieve the name of the applicable output table (attribute 'out_table') and use that name for dynamically in the loop but I don't know how to reference to the corresponding (public) variant (i.e. want to assign the variant name to the attribute 'out_table' and add values to it). I hope that someone can help me with this!

Please Login or Register  to view this content.