Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a field name 'State' which is present in two different tables.
In table A the 'state' field contains values in short form eg ' CA', and 'TX' , in the other table B the 'state' field contains values such as 'CALIFORNIA', TEXAS'.
How do I map these two together for my app?
Could you please help?
A.State | B.State |
CA | California |
TX | Texas |
Thankyou
There is no inherent way to convert short form states to long form states, but given that the list of states is fixed, you should be able to easily do this with a mapping load or join based on an inline table, or even just by loading it in itself (which will create a third table connecting A and B via state).
Load * Inline
[A.State, B.State
CA, California
TX, Texas]; // etc - just pull a list of states and abbreviations from online or from your database
There is no inherent way to convert short form states to long form states, but given that the list of states is fixed, you should be able to easily do this with a mapping load or join based on an inline table, or even just by loading it in itself (which will create a third table connecting A and B via state).
Load * Inline
[A.State, B.State
CA, California
TX, Texas]; // etc - just pull a list of states and abbreviations from online or from your database
@Or thankyou!