community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

How to a suffix a text to first column of each alternate row or each third row ?

 
Fireball

Hello @luthramanish,

 

The following flow shows how you can add a suffix to every rows. Using the Mod function on a Record ID we can determine if a row falls in every x rows and then apply the suffix you want to it.

 

Capture.PNG

 

Sam :)

Pulsar

Here's one way. You can change the Sample tool to be 1 of every 2 or 3, etc.

 

add text to alternative rows.png

Thanks Sam, my bad.... I should have asked the clear question. 

My problem is following :

I want to add "suffix1" at 2nd row and "suffix2" at 3rd row and so on.....

 

InputOutput (what I want)
NewyorkNewyork
AustraliaAustralia_Suffix1
SydneySydnex_Suffix2
DubaiDubai
CanadaCanada_Suffix1

Thanks David, but it seems a complex one. Sam's look simple. Thank you !!

Fireball

Hi @luthramanish,

 

No problem, try this:

 

Capture.PNG

Also, @DavidP's method is equally valid, just a different approach :) 

 

Sam :)

@SamDesk  - Awesome !! thank you very much ..

Fireball

No problem @luthramanish :)

 

If you could mark my previous post as solution then the thread can be closed.

 

Sam :)

Labels