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
SOLVED

Remove Duplicates in a table

Highlighted
Meteor

I am looking to create a table similar to the table below

 

A1
 2
 3
 4
 5
B6
 7
C8
 9
 10

 

from data that looks like this

 

A

1
A2
A3
A4
A5
B6
B7
C8
C9
C10

 

In my attached workflow, an IF statement via the Multi-Row Formula comparing one row to the row above it gives the following:

 

A1
 2
A3
 4
A5
B6
 7
C8
 9
C10

 

Pulsar
Pulsar

Hey @BradBaker 

 

One way to accomplish this would be to use your Multi-Row Formula tool to create a third column that is 1 if the value in your first field changes and 0 otherwise. Like this:

iif([Row-1:Field1]=[Field1],0,1)

Capture.PNG

 

From there, just add a normal Formula tool that says if your new field is a 0, make your original field blank and otherwise keep it the same value. Like this:

iif([New Field]=0,"",[Field1])

Capture2.PNG

 

Hope this helps!

Meteor

Thanks @BarnesK .  That does work.  Still looking for something that wouldn't require a workaround - something like changing the settings in the Summarize tool, but this definitely works.

Labels