topic Data Load problem in QlikView

Data Load problem

Mon, 21 Dec 2009 15:38:23 GMT

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

Data Load problem

prieper — Mon, 21 Dec 2009 15:46:25 GMT

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

Data Load problem

Mon, 21 Dec 2009 16:09:37 GMT

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

Data Load problem

prieper — Tue, 22 Dec 2009 02:54:22 GMT

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