topic Re: error handling script getting error(Script line error) in QlikView

error handling script getting error(Script line error)

Wed, 27 Nov 2013 10:20:32 GMT

Hi All,

I am using below script for error handling geeting error message (Script line error).

Please help me.

Set vConcatenate = ;

sub ScanFolder(Root)

for each FileExtension in 'txt'

for each FoundFile in filelist( Root & '\Protection_*.' & FileExtension)

                              set ErrorMode=0;
                              Protection:
                              LOAD
                              ID,
                             Name,
                             Premium,

                             FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

                              Set vConcatenate = Concatenate;

                              if ScriptError=11 then

                              next FoundFile

                              else


                              for each FoundFile1 in filelist( Root & '\Protection_*.' & FileExtension)

                              Protection:
                             LOAD
                             ID,
                             Name,
                             Premium,
                             FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

                              Set vConcatenate = Concatenate;

                              next FoundFile1

                         endif



          next FileExtension

for each SubDirectory in dirlist( Root & '\*' )

call ScanFolder(SubDirectory)

next SubDirectory

end sub

Call ScanFolder('C:\Production\Life\Data');

Regards

Ashish

Re: error handling script getting error(Script line error)

Aurelien_Martinez — Wed, 27 Nov 2013 14:00:15 GMT

Set vConcatenate = ;

Set vtest = ;

sub ScanFolder(Root)

for each FileExtension in 'qvd'

for each FoundFile in filelist('$(Root)\*.$(FileExtension)')

set ErrorMode=0;

Protection:

      LOAD
          ID,
          Name,
          Premium
       FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Let vtest = ScriptError;

Set vConcatenate = Concatenate;

if '$(vtest)'<>'Field Not Found' then

Set vConcatenate = Concatenate;

for each FoundFile1 in filelist( '$(Root)\*.$(FileExtension)')

Protection:

      LOAD
          ID,
          Name,
          Premium
       FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Set vConcatenate = Concatenate;

next FoundFile1

endif

NEXT FoundFile

next FileExtension

for each SubDirectory in dirlist('$(Root)\*' )

call ScanFolder('$(SubDirectory)')

next SubDirectory

end sub

Call ScanFolder('D:\Projets\QlikView\Concours AM-DV\5-QVD');

Re: error handling script getting error(Script line error)

Thu, 28 Nov 2013 13:47:24 GMT

Hi,

The above script given me duplicate record.

Duplicate record is comming because it relode one file three time

I want it's relode one file only one time.

Regards

Ashish

Re: error handling script getting error(Script line error)

Thu, 28 Nov 2013 14:12:31 GMT

Please help me urgent basic.

Re: error handling script getting error(Script line error)

Thu, 28 Nov 2013 14:38:29 GMT

Hi,

i am wating for your reply it urgent for me.

I culd not find any soluation.

Please help me.

Thanks in advance.

Regards

Ashish

Re: error handling script getting error(Script line error)

Thu, 28 Nov 2013 14:44:15 GMT

Hi Ashish,

you are using 2 for each loops and loading the same file from the folder, thats y the duplicate issue.

I think the below script should solve your problem.

Set vConcatenate = ;

sub ScanFolder(Root)

for each FileExtension in 'txt'

for each FoundFile in filelist( Root & '\Protection_*.' & FileExtension)

set ErrorMode=0;

Protection:

LOAD

ID,

Name,

Premium,

FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Set vConcatenate = Concatenate;

next FoundFile

next FileExtension

for each SubDirectory in dirlist( Root & '\*' )

call ScanFolder(SubDirectory)

next SubDirectory

end sub

Call ScanFolder('C:\Production\Life\Data');

thanks,

Shruthi

Re: Re: error handling script getting error(Script line error)

Aurelien_Martinez — Thu, 28 Nov 2013 14:45:29 GMT

Hi,

Set vConcatenate = ;

Set vtest = ;

sub ScanFolder(Root)

for each FileExtension in 'txt'

for each FoundFile in filelist('$(Root)\*.$(FileExtension)')

set ErrorMode=0;

Test:

      LOAD
          ID,
          Name,
          Premium
      FROM [$(FoundFile)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Let vtest = ScriptError;

Set vConcatenate = Concatenate;

if '$(vtest)'<>'Field Not Found' then

Drop table Test;

Set vConcatenate = Concatenate;

for each FoundFile1 in filelist( '$(Root)\*.$(FileExtension)')

Protection:

      LOAD
          ID,
          Name,
          Premium
      FROM [$(FoundFile1)] (txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Set vConcatenate = Concatenate;

next FoundFile1

endif

NEXT FoundFile

next FileExtension

for each SubDirectory in dirlist('$(Root)\*' )

call ScanFolder('$(SubDirectory)')

next SubDirectory

end sub

And now?

Regards,

Aurélien

Re: error handling script getting error(Script line error)

Aurelien_Martinez — Thu, 28 Nov 2013 14:58:41 GMT

Add "EXIT For" at the end (between endif & NEXT FoundFile)

Re: error handling script getting error(Script line error)

Thu, 28 Nov 2013 15:08:39 GMT

Hi,

purposely i am using two loop.

Loop1 will be excute upto script error(Filed not found).

Loop2 will be excute for no error.

Regards

Ashish

Re: error handling script getting error(Script line error)

Thu, 28 Nov 2013 15:23:48 GMT

Hi,

It again given me duplicate value and load one file three time.

Regards

Ashish