topic Re: data modeling in QlikView

data modeling

nareshthavidishetty — Mon, 25 Jan 2016 08:59:48 GMT

I have two tables ASDD and ADFG and i have a field FFFFF(cust ID) and there is no association for these two tables but i need to get the information based on cust id

Table ASDD: location,application num,application date,application source.

Table ADFG: CUST_ID

Finally i need Location->CUST_ID->application num->application date->,application source->application Status information in one table

Re: data modeling

MK_QSL — Mon, 25 Jan 2016 09:07:38 GMT

If Cust ID is not common between these two tables? Which field is common between these two tables to create association between them.. If there is no such a field, you can't find the exact values.. Yes, by forcefully joining the two tables without any common field, you can create Cartesian join.. !

Re: data modeling

tresB — Mon, 25 Jan 2016 09:11:08 GMT

Without any logical association, you can't effectively join (except cross join - which is not what you need I guess) two tables. Data modelling can't do a miracle for you. It's very simple, if there is an association (you can think of), you can associate them and fetch data from other table.

Re: data modeling

jonathandienst — Mon, 25 Jan 2016 09:14:03 GMT

Do you need this in the script or in the front end? Assuming the latter:

I hope these tables are small. If there is no association, then QV needs to perform a Cartesian join between the tables to create your table box or straight table and this can easily run out of memory if the tables are large.

If they are small, simply add these fields as dimensions in a straight table (with expression =1) or as fields in a table box.