Free Trial

Alteryx Designer Desktop Discussions

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

Show Unique Values

matula23
7 - Meteor

Hello! I have an Alteryx output that looks something like the below:

 

Example.png

 

I would like to create a workflow that will create a new column where I will only show unique tax rates based on unique combinations of company and jurisdiction. Once the rate is show once for a combination I want the rest of the rates to be blank for each similar combination. See below column E:

 

Example3.png

 

 

I think this can be achieved with the multi row formula tool. I'm not very well versed in the formula tool, I tried creating an IF statement in the multi row formula tool to look at the tax rate relative to the previous rate and group it by jurisdiction and company, but my new field is all blank. Any help on this would be greatly appreciated!

 

 
2 REPLIES 2
Bren_Spill
12 - Quasar
12 - Quasar

@matula23 try this:

 

image.png

TUSHAR050392
11 - Bolide

Hey @matula23 You can use multi row formula and follow below steps-

1. Create a new field- Unique Tax rate, Type = String, Values of rows that don't exist = 0 or empty

2.In the group by select Company and Jurisdiction.

3. Write formula - IF Tax Rate = Row-1: Tax Rate then Null() else Tax rate endif

 

Let me know if this works

 

Labels
Top Solution Authors