Dimension of Array variable inside LET FUNCTION does not match dimension of the Table assigned
I have 4 tables with a different number of rows (1,2,3,4 rows respectively) but when I add the logic highlighted to select which table to assign to the JE_Template variable based on the values of the Statement parameter they all end up stacking the number of rows of the largest table in the if statement (4) as shown below.
Any insights as to what is going on (and a possible solution) will be most appreciated!
I inserted a line with the value of variables for reference of each iteration so you can see the right table is selected but for some reason the number of rows is always expanded to the rows of the larger table (table 4 in this case). Also, in the case of Table 1 which has only 1 row I don’t understand how the JE_Template displays 3 rows populated. I also tried to filter based on the content of the JE_Template but functionality was limited and hit/miss.
I have 4 tables with a different number of rows (1,2,3,4 rows respectively) but when I add the logic highlighted to select which table to assign to the JE_Template variable based on the values of the Statement parameter they all end up stacking the number of rows of the largest table in the if statement (4) as shown below. Any insights as to what is going on (and a possible solution) will be most appreciated! I inserted a line with the value of variables for reference of each iteration so you can see the right table is selected but for some reason the number of rows is always expanded to the rows of the larger table (table 4 in this case). Also, in the case of Table 1 which has only 1 row I don’t understand how the JE_Template displays 3 rows populated. I also tried to filter based on the content of the JE_Template but functionality was limited and hit/miss. Read More