Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Concatenating 2 rows in the same column

johnnyt
6 - Meteoroid

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

 

 

 

4 REPLIES 4
Qiu
20 - Arcturus
20 - Arcturus

Maybe you can try to use IsEmpty function, somehting like

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

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

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
6 - Meteoroid

Hi Ganesh,

 

It worked, thanks for the solution!

 

 

Labels