This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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
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.
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.