Hello, I'm new to the Deonodo coummunity. I'm currently working on a poc using two Exel datasources I've created and built views on top of. I am trying to join two of these views together based on a field that contains a calendar quarter. In one field I have the data represented as: q1, q2, q3, q4 to represent quarters. In the other view I have data respresented as: Qtr 1, Qtr 2, Qtr 3, Qtr 4. Both fields are text datatypes.
In traditional SQL, there are a few methods I could use to join these together easily. However, I am having trouble joining these views with the given operators. Is it possible to join them together through Denodo, or am I expected to transform the data outside of Denodo before importing?