Evaluate the expression which is located in table as a string.

[pavan045]

I have a table like below which consists of expressions as feild values.

I need those expressions in this table to get evaluted when i load them into a straight table.

Thank you

[sunny_talwar]

May be with a dollar sign expansion?

$(=Sheet_Name)

[swuehl]

This will only work with a single Sheet_Name as possible value.

If you want to create a table with dimension ID and using the appropriate expression per ID, I believe you need a pick() or pick(match()) solution:

Pick( ID,

Sum(Value),

Count(Value),

Avg(Value)

)

You can build this expression upfront as variable in the script using the table with ID and expressions and CONCAT() function.

edit: removed typo

[petter]

If you do this - you will keep the static strings as well:

     If( Flag = 1 , $(=Sheet_Name) , Sheet_Name )

[Peter_Cammaert]

Or you could quote the simple text strings in your original table. Which IMHO is more consistent with your original expression-based set-up.

[Peter_Cammaert · Accepted solution]

This document may be useful. A screnshot of the output (I added some data where needed).

In the future, please don't post example data as a screenshot. Nobody likes copying text from an image...

Best,

Peter

[Peter_Cammaert]

Actually and on second reading, this is just an illustration of Stefan's earlier explanation. Points should go to him.

[MarcoWedel]

Hi,

one example of Stefan's and Peter's solution in the front end only:

hope this helps

regards

Marco