Field Data Type
We've encounter a dilemma where we want to make a join with an Advanced Append (connecting the current report to another view).
The problem is that the connection should be made on a field that has a numerical data type, with a varchar.
When the master query is made from the view that contains the text field, dragging the number field from the other view will aggregate the field.
When the master query is made from the view that contains the numerical field, dragging the text field will end with a red pop-up saying the data type doesn't fit.
Can you please help us with a solution or an idea?
We need the join to be connected between these fields, since the text-field holds both a numeric ID and a text ID, and we want to extract the numerical IDs only that appears on the other field.
Dor & Tal