Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, guys!
I have a problem here with Joins.
This is my first Table:
This is my second table:
I need to join them, so that I'll get a table with Employee, Account, Period , DataAccount and Bench.
I make it like:
Left Join(Table 1) Load Employee, Bench as Bench_FTE Resident 1;
But all I get is :
Or change the overly complex calculation of the Period column in Accounts and Bench into something like:
...date(MonthStart(date#(Period, 'DDMMYY')), 'MMM YY') AS Period, ...
Exactly.
Date formatting is easier with the date#() function. And, MonthStart() here is necessary for the Period match.
Guys,
I checked, there is no day in the date format, I used the previous code that Peter gave me. I think the problem is not in the date format.
However, while using Left join I have duplicate values.
What is the original format of your Month and Period fields?
It's working!!)
it's String
