topic Re: Adding values to a subcolumn? in QlikView

Adding values to a subcolumn?

Nitaci — Tue, 29 Nov 2022 10:23:55 GMT

Hello all,

I have the table of type

Talbe1:

+--------+-------+
| Name1 | Value |
+--------+-------+
| A | 3 |
+--------+-------+
| B | 4 |
+--------+-------+

and I also have a have another table that looks like

Table2:

+--------+-------+
| Name1 | Name2|
+--------+-------+
| A | A1 |
+--------+-------+
| A | A2 |
+--------+-------+
| B | B1 |
+--------+-------+
| B | B2 |
+--------+-------+
| B | B3 |
+--------+-------+

Now I want to combine these tables in such a way, that I get

FinalTable:

+--------+-------+-------+
| Name1 | Value | Value |
+--------+-------+-------+
| A | A1 | 3 |
+--------+-------+-------+
| A | A2 | 3 |
+--------+-------+-------+
| B | B1 | 4 |
+--------+-------+-------+
| B | B2 | 4 |
+--------+-------+-------+
| B | B3 | 4 |
+--------+-------+-------+

All of the tables are loaded trought standard load.
Load * from Table1

I've tried using join, concatenate and apply map, but I've had no succes. Any tips?

Re: Adding values to a subcolumn?

MayilVahanan — Tue, 29 Nov 2022 10:36:59 GMT

If both tables has common field (Name1), in that case, its normal Qlik behavior to get ur desired results.

Not sure, how its not working, did u check the table viewer to confirm the tables are join (linked) correctly.

Re: Adding values to a subcolumn?

Or — Tue, 29 Nov 2022 10:38:48 GMT

If both of these are loaded from the same source table, and they're both simple loads, why not just:

Load Name1, Name2, Value

From Table1;

Otherwise, a straightforward JOIN should work here:

Load Name1, Value

From Table1;

Left Join

Load Name1, Name2

From Table2;

If these don't solve your problem, you'll likely need to do a better job of explaining the issue, as this solution should work with the scenario and sample data you described in your post.