Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
PFA.
We have created 2 tables key is comman in 2 tables.(Key is composite key bu using resp fields in table).
But for some fields like
00610|LC|001410|2060
00620|LC|001410|2060
00670|LC|001410|2060
associated values are not showing though values are present in backend db.
Can you please suggest on this.
Thanks
In Your scenario i found you joined the both tables and filtered the data properly.
Relative values are getting shown others not shown when you go for selection.
\
hi ,
umamahesheswara any solution we can get .
thanks
Hello experts,
There are some problem with Key (On joining between the two tables).
Can you please suggest how shall i go ahead.
How should i join the two tables so that problem might be rectified.
Thanks
Hi All,
Can you please suggest how should i join the two tables.I am not able to get this.Can you please help me out.
Thanks
Hi,
in Your example there is no key from table AR_CustomerLedger, se pic.
You need share the data set ...requirements your trying to achieve and sample app then we could understand help you in sorting out the same
It also looks like you have different granularity in the 2 joined tables. This could lead to unexpected values in Your Charts. You need to find the lowest common keys to avoid this.
Maybe you should try to concatenate the tables instead.
Hi Staffman,
Thanks for the response .
Can you please suggest how would be the sequence of key as per granularity.
Thanks
Maybe you have find the lowest keys, i dont know. But in Your case it seams that you have one aggregated qvd (
AR_VarianceSummary_Custom.qvd) and one transaction table (AR_CustomerLedger.qvd). I should not join these, I should concatenate or maybe use a normal association between the tables With "key" as Your Associated key.