This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a field that contains numeric value and letters. i can seperate them if the need be, but what i am trying to do is to link the join the numeric part with another table and output the letter parts, i am not sure what tool i can use to do this. As an example
I know how to separate the column what i want to do is to maybe keep the two variable and then join the numeric part to another table column and then output the values as the text ( for example join 1 and 1 output registration)
variables 1 - Registration 2 - Walk-In 3 - Hospital Encounter 5 - Canceled 6 - Unmerge so i want to join the numeric part of table 2 column 1 to that of the column1 table 1 and get an output of the the second part of table 2. for instance 1 and 1 join give registration as shown that 1 in table2 column 1 means registration.
So are you trying to look for "101" to match to 1, or will there be an exact match in the ENC_TYPE_C column?
As is, you could probably check if the ENC_TYPE_C = 50, otherwise subtract 100 and then use Join Tool to join on that, removing the unnecessary columns when you're done. However, to figure something out to do this in general I'd need a better understanding of all the possible ENC_TYPE_C values.