Qlik Automation CSV Files in Space

[dmac1971]

I want to load and compare two csv files stored in a space.  Basically I want to load all open orders, identify those that are short stocked, open our list of open PO's and then compare the next PO to see if it will address shortfall, thus giving us a potential ship date.

Is this possible in an automation?  The csv files will be created by 2 other reports and stored each morning.

[nevopotokcloudinary]

Hi,

Question in general about the concept of export the data into CSV, why not creating simple app that pull those CSV's do the comparison and filter according to the logic and provide you simple table with the relevant orders.

after that you can send this table via email or as alert

Hope this help

Nevo

[dmac1971]

I dont believe, natively in Qlik, that this can be done.  Lets say we have an open order for qty 3, the next po will have 4.  We need to consume only 3 of these and let the 1 roll over to the next request.  Or vice versa, we need 5, next PO has 3, then a week later we get another 4, then we need to indicate that the available date will be when the 4 come in, and then we roll the 2 left over to the next order etc.  Easy to do in for example Python, not so sure in Qlik?

[tolange]

Hi,

to my knowledge, it is not possible to open and read CSVs stored inside of Qlik Cloud via Automations - I would also greatly appreciate a way to do this. If you have the files in a supported cloud storage (S3 etc.), you may read them from there. You could then use custom python logic in the Automation (Custom Code block) to do your comparison.

[pauljohansson]

@tolange 

To me it also doesnt seem to be possible to open/read CSVs stored inside Qlik Cloud using Application Automation. I find it supprisng since so many other connectors are supported. 

br

Paul