Hi All, Trying to get a dataset build for Analytics workbooks. The problem I have it there is no direct single link between the dataset sets but the join I require would be it would be something like this:

to_char(customRecord1.date, 'WW') == to_char(customRecord2.date, 'WW') && customRecord1.locationId == customRecord2.locationId && customRecord.customer == customRecord2.customer

has anyone managed to get join like this working and if so how? Thanks in advance