Assign the column multiple values in the single variable

[Dharshini]

Hi All,

I have two columns column1 and column2 in the table. Based on the language selection AE and EN, I have to store the column1 or column2 values in the target variable.

In Variable, I have used the below condition to get the value in the variable.

Variable name: result

expression : if(wildmatch([language],'AE','EN"),[column1],[coumn2])

Then use the result variable in barchart and I got the below screenshot barchart instead of values in the column.

Expected Result:

[anat]

can u try using pick and match like

=pick(wildmatch(lng,'eng','tel'),sum(cost),sum(sal))