Joining datasets Last week & This week

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

Input

Output

Join

Database Connection

Accepted answers

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

See attached.

All comments

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

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!

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703