Conditional WHERE

dvdbly01 — Wed, 25 Apr 2018 13:19:17 GMT

Hi all,

In order to shorten my code, I loop in a list of file names that are to be loaded identically, except for the "where" clause :

FOR EACH vFichier IN '$(vHistFile_O)','$(vHistFile_P)'

LOAD

[...]

WHERE Condition;

NEXT vFichier

I would like my Condition to depend on the file name.

I have tried different solutions but nothing works and I am running short of imagination!

I have tried :

WHERE

IF ('$(vFichier)'='$(vHistFile-O)',

[LG_ETAT]<>'A',

IF ('$(vFichier)'='$(vHistFile-P)',

[LG_HT_LIGNE]+0<>0 AND [LG_ETAT]<>'A',

TRUE()

)

;

FOR EACH vFichier IN '$(vHistFile_O)','$(vHistFile_P)'

IF '$(vSrcTest)'='$(vHistFile-O)' THEN

SET vCond = '[LG_ETAT]<>' & chr(39)& 'A' & chr(39);

ELSE

IF '$(vFichier)'='$(vHistFile-P)' THEN

Set vCond = '[LG_HT_LIGNE]+0<>0 AND [LG_ETAT]<>' & chr(39) & 'A' & chr(39);

ELSE

Set vCond = 'TRUE()';

END IF

LOAD

[...]

WHERE [$(vCond)]**

NEXT vFichier

** tried syntaxes: '$(vCond)', vCond, $(Var), [$(vCond)] -> nothing works.

Has anyone any idea as of how to do that?

Thanks

Re: Conditional WHERE

dvdbly01 — Wed, 25 Apr 2018 14:01:49 GMT

Obviously, I misunderstood the problem.

After some more testing, I found THE working syntax, much simpler:

FOR EACH vFichier IN '$(vHistFile_O)','$(vHistFile_P)'

TMP_LIGCLI:

LOAD

[...]

WHERE ('$(vFichier)'='$(vHistFile_O)' AND [LG_ETAT]<>'A') OR ('$(vFichier)'='$(vHistFile_P)' AND [LG_HT_LIGNE]+0<>0 AND [LG_ETAT]<>'A');