Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

TableStructure Names

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?

Tablestructure.jpg

Thanks in advance!

6 Replies
Not applicable
Author

Do you mean change the field name?

Load

ModelID as Mid

Is that what you mean?

SunilChauhan
Champion II
Champion II

to  Changing ModelID in MID

in script use

ModelID as MID in load statement

in both Basics and CrossTable tables

Sunil Chauhan
Not applicable
Author

TS1.jpg

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?

Not applicable
Author

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.

Not applicable
Author

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!

Not applicable
Author

If you post the full table structure we might be able to show you how to eliminate the synthetic keys