tag:blogger.com,1999:blog-3174073825360154810.post9122911250898951348..comments2022-12-06T05:49:47.306-05:00Comments on QlikView Maven: Entire Load Statement in a Variable-TBhttp://www.blogger.com/profile/08386812862574514289noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-3174073825360154810.post-1916446971541957432013-01-23T07:46:28.557-05:002013-01-23T07:46:28.557-05:00I've found this approach useful in the past al...I've found this approach useful in the past also. One time particularly so, as I needed to build the load script based on available fields and then also call the script multiple times in a loop. I was even able to do a replace from a base variable with placeholders in to pick up which iteration of the loop it was on.<br /><br />Something like:<br /><br /><b>let vThisLoad = replace(vBaseLoad, '#IterNo', iColNo);</b><br /><br />It's just a case of thinking out of the box and seeing what QlikView can do for you.Steve Darkhttp://www.quickintelligence.co.uk/noreply@blogger.com