2023-08-07
Alteryx QVD Input Tool
Alteryx Custom Tool
With the findings in the previous post (QlikView Data File (QVD) - Reverse Engineering), I have developed a prototype of the Alteryx QVD input tool. Alteryx is an extremely good tool for data wrangling and contains a bundle of tools that allow simple data transformation and predictive analysis. However, it does not have the ability to deal with QVD. It only allows to read and write QVX.
Alteryx, in fact, is a good upfront data stream for QlikView and Qlik Sense. It can help business to make clear use of data with drag and drop capability to explore, transform and try new business logics. QVD integration would be benefitial for Qlik at the lower data stream in the data cycle. Sound like advertisement but it is real project experience to conclude this. QVX does not work great with heavy usage. The performance is similar to CSV. Still, QVD is the best for Qlik.
Alteryx QVD Input Tool
The Alteryx QVD Input Tool is very simple. It just takes in a QVD file and read all the content then convert it as an Alteryx output stream. The input UI is as below.
* the new Alteryx SDK is now using reactjs where it is not possible to get through the security to get the full path. Thus, there is no button to pop up a dialog to ask for file location. Instead, there is only a textfield for inputting the path. If you have any clue to get this through, it is welcome. The prototype is hoping to show the possibility to integrate with QVD files.
An Example
Taking a QVD file as an example.
The QVD file contains 2 columns named Num and Text. It has total number of 4 records. In Alteryx, the result runs as below.
If you hope to try it, you can download it in my github. https://github.com/kongson-cheung/Alteryx-QVD-Tools/blob/main/yxi/QVD%20Tools_v1.0.yxi
I have share the core files to create this Alteryx QVD Input Tool. Since the SDK includes a large number of files, I did not upload them all. If you need any help, feel free to drop me a message.
* Note: this is still very early version of prototype. It still requires a number of improvements for intensive use.
Next
The Alteryx QVD Input Tool is made up by Platform SDK, UI SDK, Python SDK. This is a first prototype for reading QVD. I am exploring a prototype of Alteryx QVD Output Tool that write QVD as output.
Thank you for reading. I hope it help you. Appreciated your sharing if you have any discussion/share want to make.
No comments:
Post a Comment