Metascanner.qvw : troubles and explanations

[#1]

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 :

 

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

[jonathandienst]

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

[#3]

Thank you Jonathan.

Any clue about my second question, please ?

Regards,

Gilles

[#4 · Accepted solution]

I just find a workaround :

[#5]

it is called preceding load