Concatenating 2 rows in the same column

[johnnyt]

Hi All,

I am running into an issue where I am trying to concatenate 2 rows in the same column but also change the string of one of the concatenated rows to [Null] or change it to blank once it has been concatenated. 

I am currently using the multi-row formula to figure out which 2 rows to concatenate based on a FileName_Matched column.

If [FileName_Matched] = 1 then [call] + [row+1:call] else [call] endif

The issue is post concatenation, I am not sure how to make the row blank. I've tried the expression below, but it changes the active row to "0". Any help would be greatly appreciated!

If [FileName_Matched] = 1 then [row+1:call] = " " else [call] endif

[Qiu]

Maybe you can try to use IsEmpty function, somehting like

If [FileName_Matched] = 1 then IsEmpty([row+1:call]) else [call] endif

[johnnyt]

Hi Qui,

Thanks for the response, unfortunately, it still turns the active row to "0". I am not sure why [row+1:row] isn't working...

[GaneshBo · Accepted solution]

Hi @johnnyt , Try this formula:

If [Row-1:FileName_Matched] = 1
then Null()
else [call] endif

Please refer the attached sample workflow.

Best,

Ganesh

[johnnyt]

Hi Ganesh,

It worked, thanks for the solution!