See below, this LOAD from Resident CPCfile is already in my load script.
"DATE" as "DATE",
month("DATE") as tmonth,
num(month("DATE")) as tmonthnum,
year("DATE") as tyear,
day("DATE") as tday
I also have this little file available that contains field schooldays which is not yet in my load script. I want to join below with above so I can include schooldays.How do I do the JOIN in the load script? I suppose I could JOIN on tmonth and tyear to access schooldays like in SQL. PLEASE HELP !!!
Also, keep in mind when you are making a key, it always helps to have some kind of delimiter between your key components. Other wise you end up key collisions which will take FOREVER to track down. Below is a simple example
LOAD *, Month & Day AS 'KeyCollision'
LOAD * Inline
11 , 2
1 , 12
The value of KeyCollision in the above table would be '112' for both rows. So I always do something like