Assign the column multiple values in the single variable

Dharshini — Mon, 20 Dec 2021 04:50:26 GMT

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:

Re: Assign the column multiple values in the single variable

anat — Mon, 20 Dec 2021 07:49:27 GMT

can u try using pick and match like

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

topic Re: Assign the column multiple values in the single variable in App Development

Assign the column multiple values in the single variable

Re: Assign the column multiple values in the single variable