Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
i Came across a scenario where i have a QVD with list of countries and sales ,and every day i get a excel sheet from client that contains the list of countries and sales that have to be deleted from QVD and in the final output we just need to show data after eliminating the values from excel sheet how can i do this when i am getting excel sheets on daily basis and how to make it dynamic?
Can anyone help with approaches
thanks
Aditya Teja
Load data from excel
Load data from QVD where not exists(key field)
Store data into QVD