Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Transposing two sources duplicates a value

Highlighted
Alteryx Partner

Newbie here...

 

I have two data sources.

One excel table that has 3 rows - a row for each region and a value in 12 columns (one for each month). Pretty simple. I've transposed this to have a region column and one date column and a value column.

 

Region A     August     10

Region A     September    7

etc.

 

The second excel sheet has many rows but still simple. There is a column for region, project name, date and a value. Rows are per project.

 

Region A    Project Alpha      300      August

Region A    Project Beta        400      August

 

When I join the two I keep duplicating the value in my first sheet because it is grouping by the project name. Thus it will look like this:

Region A   August        Project Alpha           10 (from sheet 1)    300 (from sheet 2)

Region A   August        Project Beta             10 (from sheet 1)    400 (from sheet 2)

 

Thus, when I want to just look at August and the value from sheet 1, it will show 20 and not 10 as it should.

 

Is there a way to not duplicate this value?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

can you provide a sample module with TEXT INPUTS?

 

I think it would be easier to understand and to help you with a functioning module.

 

Thanks,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
Alteryx
Alteryx

Hi Mary,

 

Given the data provided, the only way to not duplicate values will be to add a unique field to each dataset.

 

If you are joining by Region, or Region and Month, each will produce duplicates.

 

"Region A August 10" will match to both "Region A August Project Alpha" AND "Region A August Project Beta", thus producing a duplicate. 

 

Best,

Highlighted
Alteryx Partner

I was able to resolve this using the Union module instead of the Join module as it didn't create extra rows and it put "nulls" in the right place. Then I transposed my measure columns into one column and it took correctly.

 

Thanks for the help everyone.

Labels