Forum Discussion
Error Token Comma Expected 'in'
Hi, I am getting 'Token Comma Expected' error but I cannot seem to understand how to resolve this one as the error is indicate at/under 'in'. I have checked commas on all other lines and they ar...
Nevermind, I actually managed to get what I needed with this Union Join
Hi Amitchandak,
Thanks for responding.
I'll start off by what I am trying to do (maybe that will be easier).
I have a list of teams which are in 2 columns (home and away). I would like to create a third column with all distinct values from both columns as not all teams are featured in both lists.
I can then aggregate other values such as attendance, matches played etc, whereas right now I can only do that for Home teams or Away teams seperately.
Let me know if you need anything else, thanks again.
Nevermind, I actually managed to get what I needed with this Union Join