Non-Associative Data Loading

[dinuwanbr]

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

[awhitfield]

Hi,

can you upload your qvw?

Andy

[Anonymous]

can you share your script code for same?

Are you doing any Joining?

[Kushal_Chawda]

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

[raajaswin]

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

[effinty2112]

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

[#7]

Please post sample qvw to understand the data model.

[manojkulkarni]

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