Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need help in Cracking this....
Hi @Agrimjain1 ,
Please check the attached QVW file.
Let me know if you have any issues.
Some exchange rate combinations are missing in provided QVD. Try the same solution on the full set of data.
Thnxx for the qvw file but i am woking in sense and i need the code in data load editor......
please see the below code.
LOAD [Doc Currency]&date([Billing Date],'YYYY-MM-DD') as currkey,
[Doc Currency]&date([Billing Date],'YYYY-MM-DD') as currkeyI,
[Billing Doc],
[Billing Item],
Material,
[Billing Qty],
[Billing Value],
Division,
Plant,
[Pricing Date],
[Sales Group],
[Material Group],
[Cost Center],
[Sales Office],
Batch,
[Storage Loc],
ProfitCenter,
[Product Line ID],
Program,
[Sales Order No],
[Sales Order ItemNo],
[Delivery Number],
[Delivery Item],
Cost,
[Sales Organization],
[Billing Type],
[Billing Category],
[Distribution Channel],
[Customer ID],
Date([Billing Date],'YYYY-MM-DD')as [Billing Date],
[Doc Currency]
FROM
[C:\Users\Rugved\Downloads\Invoice.qvd]
(qvd);
LOAD [From Currency]&[Effective Date] as currkey,
[From Currency]&[Effective Date] as curkeyT,
[From Currency],
[To Currency],
[Effective Date],
[Conversion Rate],
[Conversion Factor]
FROM
[C:\Users\Rugved\Downloads\Currency.qvd]
(qvd);