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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

 
Comet

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

Comet

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

Comet

No problem @luthramanish :)

 

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

 

Sam :)

Labels