Concatenating 2 rows in the same column
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Developer Tools
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Maybe you can try to use IsEmpty function, somehting like
If [FileName_Matched] = 1 then IsEmpty([row+1:call]) else [call] endif
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @johnnyt , Try this formula:
If [Row-1:FileName_Matched] = 1
then Null()
else [call] endif
Please refer the attached sample workflow.
Best,
Ganesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Ganesh,
It worked, thanks for the solution!
