Hello Expert,
I am writing an expression for alarm binding.
My expression is as below:
This expression returns a dataset with [5R, 1C]
I wanted to extract the value of 1st row and wanted to display it into the one of the associated data property as shown below:
But i am not able to extract the required data. How i can achieve this?
This should be enough to extract the first part of the path:
split({fullItemPath}, '/')[0]
If it doesn't work, you'll have to show us what goes wrong.
fullItemPath: NewProvider_SJP/Legrand_India/Jalgaon/Mould_Shop/Arburg 2/Phase1_Voltage
With expression: split({fullItemPath}, "/")[0]
output: NewProvider_SJP
With expression: split({fullItemPath}, "/")[1]
output(Blank):
I also wanted to extract other strings.
You need both row and column. If you put only one, the row defaults to 0.
split({fullItemPath}, "/")[1, 0]
> Legrand_India