Jump to content

How to Translate Column Names?


AJDallas44
 Share

This topic is 2872 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I've got what appears to be a simple issue, but I can't find any answer to it. Here it is:

 

(1) I have a large table with 50+ columns, and all of the column headers are in Spanish. Call it data_table.

 

(2) I have another table with 2 columns. These two columns contains all the Spanish titles from the first table, and the English translation. Call it translation_table. 

 

(3) I want to create a third table that has all of the data from data_table, with the translated column names from translation_table. So just a new table, with the data of data_table, with the column names translated. 

 

This seems like it wouldn't be difficult, but my Googling around hasn't found an answer. Maybe it's a rare situation. Thanks for your help! 

 

 

Link to comment
Share on other sites

(3) I want to create a third table that has all of the data from data_table, with the translated column names from translation_table.

 

Do you mean you want to create a new table with new, translated field names? This cannot be automated inside Filemaker: there is no mechanism for programmatic changes to the schema.

 

Consider exporting your data to a format that preserves field names (i.e. Merge, Excel or XML), translating the names in another application (or even in Filemaker, after importing the field names as data), then importing the result into a new table.

 

 

--

P.S. Please update your profile to reflect your version and OS.

Link to comment
Share on other sites

This topic is 2872 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.