🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

[SOLVED] Join Issue

User: "rowan_g"
New Altair Community Member
Updated by Jocelyn
Hi,

I'm trying to Join 2 tables read from excel files.
The IDs are a mix of text and numbers for example:
893655A
6478465
635863A
In excel, both ID fields are formatted as text.

I've changed the "data set meta data information" on both the read operators to polynomial...then I tried text, numeric and a couple more.
Problem is that when I select "text" - only the IDs with the text suffix join i.e. 893655A and 635863A and not 6478465
When its numeric/nomial/polynomial ect ect only the number IDs join.

Any help would be much appreciated.

Cheers,
Rowan

Find more posts tagged with

Comments

No comments on this post.