Multi row tool

[Tid14]

Hi, 

I am having doubt in applying one of the expression using multi row tool where I need to take the value given in 2nd row of “Reference part numbers 2” column in 1st row.

Any help on this?

 

[Qiu]

@Tid14 
I think it is just the case shown in the sample flow of Multi-row Formula tool?

[Tid14]

 
it shows this error

[Qiu]

@Tid14 
This error most likely indicates that you have not named your new column.
If you can upload you sample flow, we can take a look.

[Raj]

@Tid14using multi row formula 
1 -update the original field
2- formula - IF IsNull([Reference Part Number 2])
THEN [Row+1:Reference Part Number 2]
ELSE [Reference Part Number 2]
ENDIF

hope this helps.

[terry10]

Do you have "Update Existing Field" checked?