Not able to join of three s3 datastes

Hi @Venkat.Metadata

In general Calculated fields in dataset are available for joins. Refer the documentation that has the details

There may be some limitations since you have datasets from two different datasources. There is an article in the learning section. You can go through the same.