The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
[SOLVED] Join Issue
Contributor II
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
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
0
