Joining datasets Last week & This week

[scottjanse1]

Hi all,

I have another (simple) question. I would like to combine last week's data set with this week's data set (attached) but some of the songs have been purchased and I would like to see the growth between this week and last. But before doing this they need to show up in one data set.. I am having trouble joining the two and the one that have been purchased this week and not last week. They do not show up.

Can someone help me?

Thanks,

Scott

[jdunkerley79]

You are very nearly there.

Think all you are missing is to union in the R(ight) output of the Join adding a Right_q = 0 like you have for the L(eft) output.

For reference:

Left contains just the records from Book1 not found in Book2

Right contains just the records from Book2 nr found in Book1

Join contains just the records found in both

[scottjanse1]

I can't seem to do it :( I Have added a formula that calculates the nominal growth, but it seems to be messed up...

Could you (or someone else) take a look at this for me? It should be simple but I think I am missing something...

Thanks in advance!

[jdunkerley79 · Accepted solution]

Just a couple of select tools to match the column names before the union then all works.

See attached.

[scottjanse1]

Thanks!!! This worked!

:D Happy person haha