Anybody knows how to get easily the name of a table from one of their fields?

[marcel_olmo]

I know it sounds a "not big deal" stuff. But I think it would be very helpful to know that.

I have a datamodel with 50 tables and thousands of fields. I would like to know easily if I select a field, the name of the table which the field belongs to.

By know, I'm goin to the script and I do a loop search between all the tables.

I hope there would be an easily way to find it.

Thanks!

[IAMDV]

Very good question. I generally use Qualify & UnQualify keywords in the Load Script. This may not be the same solution but it helps me to identify the table names and I would always have full control of my data model.

Cheers - DV

[nagaiank · Accepted solution]

Did you try examining System Table?

On any sheet, right click, Select New Sheet Object -> System table

You will get a pivot table object of tables and fields.

Search Qlikview help on 'System fields' for more information.

Hope this helps.

[marcel_olmo]

Hey DV I think this is not a good workaround, because you always need to do a qualify in your script.

I'd prefer the second workaround.

Many thanks anyway.