Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

We’re aware of an intermittent issue with our My Alteryx login and are actively working to have the issue corrected. If you run into an error when logging in, please try clearing all cookies or accessing the community on a different browser. Thank you for your patience!

Dev Space

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.

Row Formula

AS
8 - Asteroid

Hi Experts,

 

Can you please help me in solving this. If in similar Company code, Emp Name is appearing 2 times so we need to choose only Fixed type row.

 

Company CodeNameType
101AlexFixed
101AlexVariable
121NemoVariable
120MichealVariable
123ActFixed
121NemoFixed

 

Output-

Company CodeNameType
101AlexFixed
120MichealVariable
123ActFixed
121NemoFixed

 

1 REPLY 1
binuacs
15 - Aurora

@AS 

binuacs_0-1648123405460.png