Table With Blank Values

Fri, 15 Jun 2012 05:56:01 GMT

Can we have a Table like this with blank rows ??

User_id	Region_ Id	Sub_User_id	Plan_id
1	1
2	2
3	3
		4	1
		4	2
		5	3
		5	4
		6	5
		6	6
		7	7
		7	8
		8	9
		8	10
		9	11
		9	12

User_id	Sub_User_id
1	4
1	5
2	6
2	7
3	8
3	9

Re: Table With Blank Values

Anonymous — Fri, 15 Jun 2012 06:38:51 GMT

Well, if you join the two tables (User_id + Region_id and Sub_User_id + Plan_id) you'll create a carthesian product, i.e. every combination of the two tables which seems to be what you're looking for in the resulting table. Be prepared for a lot of combinations if you have more data though when joining tables without any common fields. 1000 rows times 1000 rows quickly becomes one million combinations etc.

topic Table With Blank Values in QlikView

Table With Blank Values

Re: Table With Blank Values