Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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
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.
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.