Field Data Type

Tal Mickel shared this question 3 years ago
Answered

Hey!


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.


Thanks

Dor & Tal

Comments (4)

photo
1

Hi Tal & Dor,

in this situation I would definitely edit the view and drag in a 2nd occurrence of the varchar column and then apply a converter to it to change it into numeric:


24ec12ef01656203898334aa2d65970f


or another way to accomplish the same thing would be to use a Virtual Table instead of the Drag'n'Drop table, and CAST the varchar column in there.


regards,

David

photo
1

Hi Tal & Dor,

just wondering whether that suggestion helped you resolve the dilemma or not?

regards,

David

photo
1

Hey David,


Thank you for your help but unfortunately it doesn't help us as we would want to...

We passed on that idea.. Thank you for your help!!

Dor & Tal

photo
1

OK Tal, although I am sorry it didn't help you!

regards

David