In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases 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
21 - Polaris
21 - Polaris

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
Top Solution Authors