topic Re: Filename with errorlog in QlikView

Filename with errorlog

rajni_batra — Tue, 26 Aug 2014 08:08:43 GMT

Hi,

I have loaded n no. of files but format of some files is different so i need to get the name of these files which have format issue.

Plz help u guys have any idea to resolve

datanibbler — Tue, 26 Aug 2014 08:29:08 GMT

Hi Rajni,

I don't have Winrar here. What kind of formatting are you referring to? In what respect can the files differ?

tresB — Tue, 26 Aug 2014 08:35:08 GMT

Load the filenames when ScriptError<>0, like;

LET vErrorLog=NULL();

SET errormode = 0;
LOAD *,
FileBaseName() as Filename
FROM
[..\Desktop\CRM\Test\CRM*.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);

if ScriptError <> 0 then

LOAD *,

FileBaseName() as ErroFilename

FROM

[..\Desktop\CRM\Test\CRM*.csv]

(txt, utf8, embedded labels, delimiter is ',', msq);

ENDIF