Hope someone can help with this requirement. I have a table with qualified fields which I want to display on a table box, with the unqualified field names as labels. So for example, my field name would be something like "MYLOADTABLE.PRODUCTS_MASTER" but I want the Dimension label on the Table box to read as "PRODUCTS_MASTER" and so on.
I have seen some posts where macros were used to achieve this by running the rename in a loop but this seems to be a very slow approach. Does anyone know a quick way to do this? Or any examples where this has been achieved?
P.S. It is not feasible to rename the fields in the load script and also not practical to manually rename the fields in Table Box Properties as the table has almost 80 fields on it, and I would like them all renamed in this fashion. Also, if a working solution is available for a Straight table, I can live with that too.
Thanks for the note Gysbert. This is because the bit of the string in the field's name I want to substring is the qualified name. It is a huge data model and there are likely to be many (undersirable) associations that will result if I effectively "unqualify" all the fields
I don't see why you need to unqualify fields. Just rename those that need to be renamed using a mapping table. See this blog post: How to Rename Fields
