ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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