Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day
I wonder if someone could help me with my problem. I am new to QlikView.
I load the following table from a text file:
Table A
Field A
Field B
Field C
Field D
This table is loaded and includes some concatenation and an outer join to produce the correct table. The I want to use fields from this table when I load a second table.
Table B
Field1
Field2
Field B
The resulting table should look like this:
Table B
Field1
Field2
Field B
Field A
I have tried this through an inner join to the resident table, but all the values from Field2 are then duplicated and I don't get the correct result.
Any suggestions?
Thanks
Can you load some example, along with the result you expect to see?
So far the behaviour is normal: Field B is the linking key, when you join both tables, you need to have just one record with Field 1 and Field 2 for each Field A.
Peter
The graph shows the results as expected. I have commented out the load statement that does not give the correct result.
Just let me know if I must add something more.
Thanks for the help
No, think that QV will do it with it's internal logic. Your script should look like
LOAD FieldA, FieldB, FieldC, FieldD FROM .....;
JOIN LOAD FieldB, Field1, Field2 FROM ....;
HTH
Peter