Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a data model , which is GL Table , and in order for me to provide more information to the GL Table , i add the sales Table , so that user are able drill in and get more information on sales from which customer.
After i add the sales table , i am not able to make use of my currency rate variable , as it does not work. it give wrong rate. Hope some one can share with me how to solve this ?
Paul
try to use left keep or right keep which you want
To provide you more info , i enclosed below the data model before add sales table work fine one currency variable.
Below image shown after i add sales table , my currency rate not working :-
My issue is the may be due to i join wrongly , i should make the sales table inside GL table.
Hope some one can share with me how to join,
Paul
Hi Paulyeo11,
Do you realy need to join?
Can't you concatenate the sales table into the GL table?
I think you may leave sales_table as a linked table,
but I suggest you replace "date" with "sales_date" to break the circular reference
(use date As sales_date
in your load statement)
Then you should probably have a separate salescalendar table linked to sales_table via sales_date
/gg
Try to use left join if your Gl_Table has more Gl_Code which are exists in sales_Table
So, for this you use Left join
if don't know try to use only join then your Sales_Table into Gl_Table.
hope it helps
Hi Jeroen
I can not concatenate . Because both table field are different and I have 5 diff sales table and GL Table from diff country.
Any way thank you for yr reply.
Hi Gan
I have already try what you mentioned on all the point. But I still cannot figure out why after add sales table it affect my vCurrency variable.
Thank you for yr advise.
Hi eR
Thank you for yr suggestions.
I try left john csnnot work because it will make my file become very big.
Link should be right. But it affect my var on exchange rate.
try to use left keep or right keep which you want
PaulYeo11,
What er.mohit is telling is also a possibilty.
I would use the Where exists functionality because that's beter from a performance point of view.