Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am looking to create an app which would allow me to track changes within base list. So with the first load I want to load a list of products that belong to specific product line which will be my baseline. Then on a monthly basis I would load there list of products from entire company and check it against my existing baseline to identify:
- if any details of the existing products have changed
- if some products were removed and which
- if products were added to this specific product line - if yes add to the baseline
I was wondering how should I go around my load to get desired results? Any help will be greatly appreciated!
Hello,
I believe that this use case scenario is very specific and most probably very complicated to achieve in Qlik Sense, if it is even possible to do so 100%. Qlik Sense is mainly used to analyze data from a dataset, rather than prep and process the data. However, in your specific use case scenario, you have a lot of checks and you might need to use multiple functions to achieve, at least, some parts of it.
In case other community members might be able to help you achieve that by sharing with you a complete Data load editor script it will be great, but please allow me to share with you a general logic behind a successful implementation:
You can make all the processes with a Python script and then use Qlik Sense to load the processed data and present it. The general idea would be to follow similar steps as below:
As you can see, the logic behind the process is fairly complicated and this is why I believe that it is going to take a lot of effort to achieve it within the Qlik Sense Data Load Editor script directly. Additionally, you can take a look at the Data Prep [1], where it is stated "Data prep involves taking raw data from multiple sources, cleaning it, validating it, structuring it and enriching it to prepare it for use in business analytics and business intelligence (BI) projects."
You can also reach to the proper team for support, by clicking "Contact us" and discuss the use case scenario that you have. I believe that you might be able to achieve most of your use case scenario if not 100% of it.
I hope that this information was helpful!
---
[1] https://www.qlik.com/us/data-ingestion/data-prep