Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Metascanner.qvw : troubles and explanations

Hello,

I am currently trying to use metascanner.qvw which is available on this website.

Firstly I need to understand a step in the script which is curious for me :

  script extract.JPG

When I execute only with the first load then table Filelist is not created.

And when I execute only with the second load,  the table Filelist is created but only with field FileName.

My first question is how the first load can use things coming from the second load ?!?

Besides I have file names like for example : [DR] Direction Reglementaire.qvw... the script fail in error because of special characters [  ],  but the field is already double quoted.

My second question is  how should I modify the script in order to pass file names with special characters ? Please note that I cannot rename all my applications.

Many thanks in advance for your help,

Gilles

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Metascanner.qvw : troubles and explanations

I just find a workaround :

script extract.JPG

4 Replies
MVP
MVP

Re: Metascanner.qvw : troubles and explanations

Gilles

The first load has not from clause (from/resident/autonumber), so the second load is acting as the from clause for the first. In other words the first load acts on the output from the second load - in this case enriching the file name retrieved by the second load.

I am not sure of the correct name, I call this a dependant load.

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Metascanner.qvw : troubles and explanations

Thank you Jonathan.

Any clue about my second question, please ?

Regards,

Gilles

Not applicable

Re: Metascanner.qvw : troubles and explanations

I just find a workaround :

script extract.JPG

Not applicable

Re: Metascanner.qvw : troubles and explanations

it is called preceding load

Community Browser