Concatenating 2 rows in the same column

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

Pre_Concatenate.PNG

Post_Concatenate.PNG

Workflow

Developer Tools

Transformation

Accepted answers

GBO95

Hi @johnnyt , Try this formula:

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

Please refer the attached sample workflow.

Best,

Ganesh

Concatenate_Sample.yxmd

All comments

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...

GBO95

Hi @johnnyt , Try this formula:

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

Please refer the attached sample workflow.

Best,

Ganesh

Concatenate_Sample.yxmd

johnnyt

Hi Ganesh,

It worked, thanks for the solution!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280