data model problem

[#1]

hi QV's ,

Please find App below ,

my problem is why i am getting Synthetic key can you please resolve

[#2]

hi , plz find attachment

-lohi

[#3]

hi , any one got the result

-lohi

[#4]

Hi Lohi,

I could see your excel file and could not look at QVW.

But looking at excel tabs I could not understand how are you getting Syn table in Data model.

Could you please attach data model in some other format?

Regards,

[#5]

hi , plz check

[alex_millan]

Perhaps I missed something but, what's the point to create a field to accumulate sales when you can do it after scripting by means of expressions?

[#7]

Hi Lohi,

Now its even more confusing.

I think first you are joining both tabs data from excel then doing some calculation (cumulative).

I think if you will load excel tabs separately then Syn table issue will  not arise, if u can share your load script as well then may be I will be able to understand your data model clearly.

Regards,

[geert_gelade]

I suppose you're trying to add the commissions to the base-table based on the interval of the cumulativesales and the key "name-year".

Please find attached a possible solution without looping over the values of name and year, but by using the extended intervalmatch function.