How To Concate Three Strings In Elasticube

[intapiuser]

Question: I have requirement to combine and show the dimension. There are two dimensions Product and Product_Family. I want to display it as single dimension in charts like "Product 1 | Product Family 1", "Product 2 | Product Family 1", so on.

Solution: If all dimensions are of string data type it will be enough to use the '+' sign between them and the '|'.

If they are not strings yet, you can use the TOSTRING() function before using the '+'

You can also use the Concat function:

Concat(Concat([Product1].''),[Product2]) 

Or  Concat([Product1],[Product2])

[chitra150]

Thanks for sharing this. this is really helpful for me. I apply this in my  project during blue prism certification. I really appreciates your solution.