Hi Team, In Alteryx how do I combine these rows ? As noticed it creates duplicate rows and we just need SubName columns so eventually there will be only 5 rows Col1TypeNameSubNameCompany1AApple Company1BApple Company1CApple Company1DApple Company1EApple Company1AAppleCETCompany1BAppleCETCompany1CAppleCETCompany1DAppleCETCompany1EAppleCET Thanks

Combine rows into 5

Hi Team,

In Alteryx how do I combine these rows ? As noticed it creates duplicate rows and we just need SubName columns so eventually there will be only 5 rows

Col1	Type	Name	SubName
Company1	A	Apple
Company1	B	Apple
Company1	C	Apple
Company1	D	Apple
Company1	E	Apple
Company1	A	Apple	CET
Company1	B	Apple	CET
Company1	C	Apple	CET
Company1	D	Apple	CET
Company1	E	Apple	CET

Thanks

Developer

Accepted answers

RolandSchubert

So I think, the Summarize tool will be helpful. But - it seems, you want to keep the rows with SubName (if available). So you can use group by as already explained and "MAX" for SubName.I've attached a sample workflow. What do you think?

CombineRows.yxmd

All comments

RolandSchubert

Hi @JDong ,

what exactly do you mean by "combine"? The Summarize tool could be an option (e.g. Group By Col1, Type and Name and Concatenate SubName). Could you explain in more detail, what result you expect?

Best,

Roland

JDong

Thanks

Company1	A	Apple	CET
Company1	B	Apple	CET
Company1	C	Apple	CET
Company1	D	Apple	CET
Company1	E	Apple	CET

Expected outcome

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703