Alteryx Designer Desktop Discussions

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

Create multiple field after specific record

Istwineres
8 - Asteroid

HI, I'm looking for a solution for this problem: after a Text To Columns tool I have a single field with multiple records, I'd like to create separate field after specific record encounterd, this record is the same every time. 

Field_1

text

text

text

text

specific record

text1

text1

text1

text1

specific record

text2

text2

text2

specific record

 

Expected output:

New_Field_1     New_Field_2    New_Field_3

text                     text1                 text2

text                     text1                 text2

text                     text1                 text2

text                     text1

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@Istwineres 

Hope this is what you need.

Capture1.PNG

Labels