Qlik view

[harithad95156]

Hi,

I am having 2 transaction tables so I have used link table concept and build a data model.

In my raw data I am having invoice table and collections table. These two tables are linked with Invoice No. In collections table I am having a field like client name and some of the values with Null and in Invoice table am having client name as a field .

So how can I retrieve the data from invoice table and place them in collection table null values with Invoice number as a key.

I cannot use joins as this is a transaction table.

Please suggest me the solution in this scenario.r

[rwunderlich]

Can you remove the ClientName field from the collections table and use the ClientName from the invoice table? 

-Rob

[harithad95156]

As these are transaction tables there are no chance of renaming or deleting
fields

[rwunderlich]

You control the contents of the Qlik data model.  So you can certainly remove the field from the model either but not listing it in the load statement or 

Drop Field ClientName From Collections;

-Rob