QV hangs after making a key from a resident table

[tinkerz1]

QV is hangs when I add a key to my fact table.

What I am is doing is this

[Table1]:

Load *,

ORDERID and LOCATION AS KEY

SALESID and LOCATION AS KEY2

Calcfield as KEY3

Resident [TableA];

Drop TableA

But this is really not working its hanging really and won't continue I have identifed it as this code.

It works in the script but on smaller tables, the reason why I put the key on after is because its on a calculated field and also after a where clause so the data set is smaller.

[quwok]

It sounds like that piece of code may have added some complex relationship to your model. The "hanging" would most likely be QlikView trying to resolve it. Have a look and see if the addition of that code has created any circular references or complex synthetic keys to the model.

[tinkerz1]

How do I do that as It hangs and wont finish??

[tinkerz1]

I have renamed the field so there is no associations and still it hangs.

[cwolf]

"and" is here not correct. You have to use:

[Table1]:

Load *,

ORDERID & LOCATION AS KEY,

SALESID & LOCATION AS KEY2,

Calcfield as KEY3

Resident [TableA];

[tinkerz1]

Yes I am using '&'

I am even using

[Table1]:

Load *,

'-' as test

Resident TableA;

[tinkerz1]

Thinking out loud, by duplicating the table I am making many associations in the *, portion.

How can I add a key to table after I have added a calculated field and then reduced it by using a where clause?