topic Re: Non-Associative Data Loading in QlikView

Non-Associative Data Loading

dinuwanbr — Tue, 08 Dec 2015 09:54:08 GMT

Hi All,

I have Items table with 500 Items and Transaction table only use 230 items out of that 500. When I'm loading in general manner i got 230 as my total number of Items. But it should be 500. How can i do this?

I don't want to load Items table twice. even though there won't be a link.

Thanks in advance.

BR,

Dinu1

Re: Non-Associative Data Loading

awhitfield — Tue, 08 Dec 2015 10:08:31 GMT

Hi,

can you upload your qvw?

Andy

Re: Non-Associative Data Loading

Anonymous — Tue, 08 Dec 2015 10:12:18 GMT

can you share your script code for same?

Are you doing any Joining?

Re: Non-Associative Data Loading

Kushal_Chawda — Tue, 08 Dec 2015 10:14:54 GMT

Check how item table & transaction table are joined. Which join is used .

Re: Non-Associative Data Loading

raajaswin — Tue, 08 Dec 2015 10:14:55 GMT

Try having a flag in script, and count using that flag

Re: Non-Associative Data Loading

effinty2112 — Tue, 08 Dec 2015 14:31:12 GMT

Hi Tharindu,

Is the table view showing 230 rows for both tables?

Maybe check your load script for an inner join or inner keep? Or a where exists condition? If you can't find the culprit post the text of the script.

Cheers

Re: Non-Associative Data Loading

Tue, 08 Dec 2015 16:46:59 GMT

Please post sample qvw to understand the data model.

Re: Non-Associative Data Loading

manojkulkarni — Tue, 08 Dec 2015 16:52:47 GMT

don't join both the table. Keep it separated & add flag in items table to refer it coming from item table