Analytic View join issue between TIMESTAMP and DATE formats

[Former Member]

I have a fact table in my data foundation that has a TIMESTAMP date that i am trying to join with to my calendar table that has  a DATE format .  I am unable to query this view after creating it and it appears to be because of the data type differences.  Is there a way to convert when joining? i can not seem to find a way to do this

[raghavendra_n]

add those two tables into two projection nodes in calc view. define a calc column of type DATE on timestamp column. join these two projections.

[Former Member]

Yes, you can use a generated always statement to create a join predicate and join against that in the view.

Or you can join against the M_TIME_DIMENSION table in an attribute view to convert.

Or you can create a calculated column and do a union.

Depending on the requirements, one of these will be the best fit.