I have a usecase where I need to daily reload an app and export the straight table data automatically. How should I do that? I saw a solution using creating excel work book and looping into it and dumping , but do we have a straight forward method of doing this? Because manually it is done just by a single click.
Please let me know if any method is available or not? and how to approach this.
Well it all depends. Here are few follow up questions:
where do you want to export this data to? email? share point? somewhere else?
how many rows and columns roughly will the exported dataset have
if more than 1,048,576 rows then excel solution will not be suitable as that is excel limitation.
what sort of export format do you have in mind? .txt, .csv, .xlsx?
then there could be a question whether you could just store the output directly during reload in script command (store XYZ into xyz) but that would only apply in scenario when all data would be coming from single table in data model
Using this method is super easy, but whether or not it will suite your requirements depends on few things I mentioned above.
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
Thanks for the reply, I have only one table in the app and I need to send that table to a existing s3 bucket. The records are also not more that 1M , I have doubt here do I need to populate everything in excel and send it to s3 or can I directly bulk upload the table? I am not getting any documentation for sending table data to S3, only using data from s3 in load editor I can find .All these are a bit new to me.
Can you pls help me building the right approach here?
Sorry - you are not precise enough in providing answers to the questions I asked earlier which prevents me from giving you answer more detailed answer, sorry. So again:
In what format do you want to send this data to S3 (csv, skv, qvd, xlsx) ?
Your single table: is it already in the format you need it in data model or are we talking about UI object which has to be exported.
Now thinking about it I don't know what should I suggest. You may spend more time describing reasons as to what you do and reasons why you do those things. For example, you mentioned that you are only having single table in Qlik Sense (are you talking about single table in data model or single UI table object). If it is in data model you could use store into command + automation to send it to s3 as parquet or csv or skv or txt or qvd file (whichever you need).
But if it is UI table object workflow would be very different and more complex!
I suggest we learn more about your approach, what you have and why, and what tools you are using etc. We may as well learn what Qlik technology you are referring to. You posted in Analytics & AI forum so I assumed you are talking only about Qlik Sense, but maybe we should be talking about Qlik Data Integration? The fact you used "app" and "reload" indicates to me Qlik Sense but this is just assumption.
cheers
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
