topic Re: Duplicate values Based on Record ID in Alteryx Designer Desktop Discussions

Duplicate values Based on Record ID

batista_randy — Mon, 08 Jan 2024 17:44:51 GMT

I have Data that looks like this

1			Name1	Question 1
1				Question 2
1		CountryX		Question 3
1	XYZ			Question 4
1				Question 5
1				Question 6
2			Name2	Question 1
2				Question 2
2		CountryB		Question 3
2	ABC			Question 4
2				Question 5
2				Question 6

I want to duplicate the rows based on the number on column 1 so it looks like this. Note this is for multiple columns.

1	XYZ	CountryX	Name1	Question 1
1	XYZ	CountryX	Name1	Question 2
1	XYZ	CountryX	Name1	Question 3
1	XYZ	CountryX	Name1	Question 4
1	XYZ	CountryX	Name1	Question 5
1	XYZ	CountryX	Name1	Question 6
2	ABC	CountryB	Name2	Question 1
2	ABC	CountryB	Name2	Question 2
2	ABC	CountryB	Name2	Question 3
2	ABC	CountryB	Name2	Question 4
2	ABC	CountryB	Name2	Question 5
2	ABC	CountryB	Name2	Question 6

Re: Duplicate values Based on Record ID

binu_acs — Mon, 08 Jan 2024 17:58:32 GMT

@batista_randy One way of doing this

Re: Duplicate values Based on Record ID

nagakavyasri — Wed, 10 Jan 2024 05:43:19 GMT

@batista_randy Another way of doing this:

Re: Duplicate values Based on Record ID

flying008 — Wed, 10 Jan 2024 06:51:57 GMT

Hi, @batista_randy

FYI.

Re: Duplicate values Based on Record ID

grazitti_sapna — Wed, 10 Jan 2024 13:15:18 GMT

Hi @batista_randy
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks

Re: Duplicate values Based on Record ID

batista_randy — Wed, 10 Jan 2024 13:33:03 GMT

Hi, I don't have the option to concatenate on my summarize tool. Is there something I'm missing?

Re: Duplicate values Based on Record ID

batista_randy — Wed, 10 Jan 2024 13:49:03 GMT

Disregard my last question as I just figured out how. The problem I am having now is the values have a ",,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,," after the concatenate. What is causing this and how can I remove that? See example below.

,,CountryB,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,	,,,XYZ.,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,CountryX,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,	,,,ABC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
,,CountryC,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,	,,,BCD,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

Re: Duplicate values Based on Record ID

flying008 — Thu, 11 Jan 2024 01:20:48 GMT

Hi, @batista_randy

Maybe your fileds have many blank in the cells, so you need use Multi-Fields Formula tool to remove the unless space.