Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I am having some troubles connecting my tables from SAP because they are huge. Therefore i wanted to limit the entries. I have in SAP data since 2005 but we are interested only in data from 2023 till now. Is there a way I can limit the connection without much? I am kinda new to coding so if there is a solution without coding, it would be amazing. If coding is the only way, how could i do it?
Thank you so much.
Yes in your load script use the Where function. Ie :
FROM Sap_Table
where Dept = 'Sales' And SalesDate > '1-1-2021';
Yes in your load script use the Where function. Ie :
FROM Sap_Table
where Dept = 'Sales' And SalesDate > '1-1-2021';