topic Re: Qlik view in App Development

Qlik view

harithad95156 — Fri, 02 Apr 2021 14:54:33 GMT

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

Re: Qlik view

rwunderlich — Fri, 02 Apr 2021 15:23:41 GMT

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

-Rob

Re: Qlik view

harithad95156 — Fri, 02 Apr 2021 16:42:39 GMT

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

Re: Qlik view

rwunderlich — Fri, 02 Apr 2021 20:25:25 GMT

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