Based on the advices of this site, I append Slot and Table games datasets and was able to combine slot and table players together.  Joining causes the lesser table set (Table) to expand its rows to match with Slot if a Customer ID matches in both datasets, thereby substantially inflate my revenue. However, appending creates another problem for me. It does not combine the PlayerDayDate together.  If you check the image below with the highlighted rows, customer 43714 play date of 12APR2015 should be on one row not two and any associated revenue columns should also be combine.  How do I make this happen?  How can I combine two same playdates into one row. ... View more

When I join Table1 and Table2 by Zipcodes, not all of zips in Table1 will be available in Table2.  Therefore E.G will show the not-matching zip codes as blank. Table1 Table2 ZipCodes ZipCodes MarketingZones So any zips from Table2 does not match with Table1, I will get a blank cell under the column MarketingZones.  How do I rename the blank cell as "Other" or "Missing"? See below for sample output. ... View more

I have two tables that I want to join but the results are not I what I wanted. As you can see guest 350106 shows up three times with the same data. I think it is because of the join I did.  I used InnerJoin between GuestNumber from both tables. CharZip is from another table. Table 1 Table 2 GuestNumber GuestNumber PlayerDayDate CharZip Sales Does anyone know what I did wrong? ... View more

I looked through all the treads about  calculating age  and found  this line of code: int(YRDIF(t1.DOB, t1.PlayerDayDate, 'Year')) The line of code is valid but the column ,AGE, shows missing value or no values. What did I do wrong? My DOB and PlayerDayDate format are as follow: 22MAR2014:00:00:00 ... View more