Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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