Expression binding in Alarm binding

Ignition
1

Hello Expert,
I am writing an expression for alarm binding.
My expression is as below:

image
image731×310 12.2 KB

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:

image
image1076×534 55.6 KB

But i am not able to extract the required data. How i can achieve this?

2

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.

3

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.

4

You need both row and column. If you put only one, the row defaults to 0.

split({fullItemPath}, "/")[1, 0]

> Legrand_India