Filename with errorlog

[rajni_batra]

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]

Hi Rajni,

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

[tresB]

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