In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

Logic Query

AS
8 - Asteroid
‎04-03-2025 05:16 AM

Hi Experts,

 

help me build the logic for this so I have this input data. I need one H=Type line for a single company code. Same company code type=L lines should fall under one H line.

See the input below

TypeCoCodeNameDocTypePeriod
H45BXXX--XXX
L45BAASDU2025
L45BAASDU2025
H45BXXX--XXX
L45BBBSDU2025
L45BBBSDUS2025
H27AXXX--XXX
L27ACCGDRE2025
L27A

CC

FDre2025
H27AXXX--XXX
L27ADCDFRE2025
L27ADCGDER2025

 

 

Output-

TypeCoCodeNameDocTypePeriod
H45BXXX--XXX
L45BAASDU2025
L45BAASDU2025
L45BBBSDU2025
L45BBBSDUS2025
H27AXXX--XXX
L27ACCGDRE2025
L27A

CC

FDre2025
L27ADCDFRE2025
L27ADCGDER2025

 

Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
AS
8 - Asteroid
‎04-03-2025 06:13 AM

hi folks, I have solved it.

Preview file
36 KB
logic.yxmd
Reply
0 Likes
read certification FAQs
Labels
Top Solution Authors
View All