Alteryx Designer Desktop Discussions

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

Repeat the Next field in a column.

Shekharreddy125
7 - Meteor

Hello Community,

 

 

Security Name           ClassificationValue
A 1.26
B 1.56
Casr1.86
D 2.16
E 2.46
F 2.76
G 3.06
Hrtd3.36
I 3.66
J 3.96
Ktrd4.26

 Source 

 

Security Name           ClassificationValue
Aasr1.26
Basr1.56
Casr1.86
Drtd2.16
Ertd2.46
Frtd2.76
Grtd3.06
Hrtd3.36
Itrd3.66
Jtrd3.96
Ktrd4.26

Output

Please post the useful tools.

 

Thank you!

2 REPLIES 2
NickSm
Alteryx
Alteryx

@Shekharreddy125 

 

A multi-row tool can be used to fill down a column.  In this case you'd just have to flip the records, fill down, then flip it back using a RecordID

 

clipboard_image_0.png

 

Attaching a quick sample

 

 

Shekharreddy125
7 - Meteor

Thank you! @NickSm 

Labels