Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I want to change some of the names listed in the table structure.
Is it possible? E.g. Changing ModelID in MID or something like that.
If yes, where can i adjust it?
Thanks in advance!
Do you mean change the field name?
Load
ModelID as Mid
Is that what you mean?
to Changing ModelID in MID
in script use
ModelID as MID in load statement
in both Basics and CrossTable tables
Thank you guys, i will try it. Another question to that.. To the picture above, how can i change the names of the Joins, or is it impossible?
You will get a synthetic table when you have more than 1 common field between two tables. Try and limit the common fields between tables to 1 field by renaming certain fields.
Its not a good idea to have that many synthetic keys in your document as it will add processing overheads to your reload.
I checked the "Help" after you have mentioned "changing field names"
These two worked without problems:
rename field X to Y;
Rename table X to Xyz;
Changing the Synthetics is not possible.
Thank you guys for the help and inspiration!
If you post the full table structure we might be able to show you how to eliminate the synthetic keys