topic TableStructure Names in QlikView

TableStructure Names

Mon, 14 Nov 2011 10:47:46 GMT

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!

TableStructure Names

Mon, 14 Nov 2011 11:25:25 GMT

Do you mean change the field name?

Load

ModelID as Mid

Is that what you mean?

TableStructure Names

SunilChauhan — Mon, 14 Nov 2011 11:27:57 GMT

to Changing ModelID in MID

in script use

ModelID as MID in load statement

in both Basics and CrossTable tables

TableStructure Names

Mon, 14 Nov 2011 11:35:15 GMT

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?

TableStructure Names

Mon, 14 Nov 2011 11:45:49 GMT

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.

TableStructure Names

Mon, 14 Nov 2011 12:24:13 GMT

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!

TableStructure Names

Mon, 14 Nov 2011 12:38:56 GMT

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