Example ETL Scripts

[#1]

Hi all,

I'm new to QV but have an extensive background in BI Development using Business Objects, MS SQL Server, Oracle and MySQL so am proficient and being able to 'reverse-engineer' scripts and understand the concepts within them and what they are doing if that makes sense.

Basically I have to learn QV as fast as possible due to the typical organisational situation of 'we-can't-give-formal training-but-learn-this-ASAP' .

My question is -> so I can learn QV as fast as possible, would you be able to upload some example ETL scripts that you have used in QV in the past ?

This would be extremely, extremely helpful.

Thanks,

Davydd

[disqr_rm]

I can share my experience of learning the most in one week.

Pick a mid-size project, hire a "good" consultant for one week and work with him/her on the project. In my experiece, 80% of the mid-size QV projects can be done in one week or so. And while working on the project with him/her, have on-site training for harlf a day or so on advance stuff.

I doubt that people will upload ETL scripts here. Reason is sensitive data, big file sizes etc. The best option for you would be ask your QlikView counterpart (or partner) you are workign with. He/she can provide you many examples on the topics you may have.

Hope this helps you.

Rakesh

[#3]

Thanks Rakesh,

I will be heavily working with a consultancy for this project however I wanted to be as up to speed as possible before I fly over to learn off them.

Maybe someone will post something otherwise I will learn (hopefully as much as possible) on the job.

[rwunderlich]

They are not complete ETL scripts, but the Qlikview Cookbook
http://robwunderlich.com/Download.html
has some examples of typical scripting tasks.

What type of source data are you working with? Subject (Finance, Ops, etc) & ERP name?

-Rob

[johnw]

I'm not so sure this is a good way to learn, but I don't see anything confidential in the script in the latest application I threw together, a shipping application. Nothing particularly interesting about the script. Just a straight load of data from QVDs. But it's attached, for what it's worth. And lest it confuse you, you don't write QlikView scripts as text files. You write it in a QlikView application. But the application DOES have confidential information, and it's huge, and I don't want to scramble it, and so on. So I'm just sending you the script.

I think you're best off going through the tutorial, and then just starting in on your real application. But I suppose everyone learns differently.

[#6]

Hey I actually downloaded the cookbook recently but I'm not able to view it as I currently only have the Personal edition until our server arrives etc.

Are you abnle to copy and paste the text or send me some text files with some scripts from the cookbook? That would be really really helpful!

thanks

[#7]

Hey I actually downloaded the cookbook recently but I'm not able to view it as I currently only have the Personal edition until our server arrives etc.

Are you abnle to copy and paste the text or send me some text files with some scripts from the cookbook? That would be really really helpful!

Oh yes, source data is media / affiliate information

thanks

[#8]

thanks to all who replied!

[#9]

Hi John

That shipping script is perfect - thanks!