Data Load problem

[#1]

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

[prieper]

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

[#3]

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

[prieper]

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