Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am a beginer. I am curious to know how the tables get associated with the same Field names.
Could someone share your knowledge?
The best answer I can give is: automagically.
It's all a pointer mechanism. You should view all table columns that carry identical names as forming part of a single field that groups all discrete values from those different instances. Column values are replaced by bit-stuffed pointers that point to a symbol table where all individual field values are stored.
The Table Viewer may present a nice RDBMS-like overview, but IMHO the internal kitchen operates in a quite different way.
Peter
It is just as the relations in data diagram of SQL or data base concept.
So just go through the Relations concept in the Database concepts .
In QlikView (or Qlik Sense) you do not have to define key field to link tables to each other. The tables will be assumed to be linked to each other if they have field with identical name.
My suggestion is that you start building your product knowledge by completing the free online training. It is really worth investing time in product training, so that you get a good foundation, as data modeling is essential to becoming a successful QlikView developer.
QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik
The best answer I can give is: automagically.
It's all a pointer mechanism. You should view all table columns that carry identical names as forming part of a single field that groups all discrete values from those different instances. Column values are replaced by bit-stuffed pointers that point to a symbol table where all individual field values are stored.
The Table Viewer may present a nice RDBMS-like overview, but IMHO the internal kitchen operates in a quite different way.
Peter
the qv software is made like that(if the same field name is available then it'll map with other table same field name automatically).