Hello everyone,
I am new to Qlik and looking for guidance on integrating data from an FTP server into Qlik Sense. The challenge I'm facing is that the data in the FTP server is updated daily, and old data is regularly deleted from the database.
The file structure has a time stamp that look like this:
20240427230004580 - Clients.csv
What would be the recommended approach or best practices to set up an automated process in Qlik Sense to handle these daily changes and ensure that the latest data is always loaded into Qlik Sense? Any insights or step-by-step instructions on configuring data connections, scripting for data retrieval, and automating the process would be greatly appreciated.
Thank you very much.