ETL and Data Integration tools - Modern ETL software for everyone

Hello,

I'm using VImpX 4.7.7 and trying to filter some records.

When I use the formula in the filter -> '[F7]'=='D' , it works fine.

When I use the formula -> '[F7]'=='C' , it works fine, also.

But, when I use the formula -> '[F7]'=='D'||'[F7]'=='C' , I receive the message \"Invalid arguments for operation. Position 14\"

What am I doing wrong?

Thanks.

PS: Congratulations for the tool. It's really wonderfull.

Helmer

Script:

Datasource

DataSourceType=TEXT
OdbcDsnName=
UserName=
Password=
SourceIsTable=False
SourceTable=
SourceTables=
OdbcUseMask=False
OdbcMask=
ShowSystemTables=False
Delimited=False
Delimiter=
Quote=
CrossTable=False
FirstField=1
Blocks=1
BlockLength=1
HeaderLines=0
FooterLines=0
SourceFile=C:\Ferramentas\Papeis Trabalho Auditoria\Balanco\CTBR040.TXT
Directory=
Filter='[F7]'=='D'||'[F7]'=='C'
FileUseMask=False
FileMask=

SourceFields

:[F1]=[1,1]
:[F2]=[2,16]
:[F3]=[17,31]
:[F4]=[32,80]
:[F5]=[81,184]
:[F6]=[185,203]
:[F7]=[204,204]
:[F8]=[205,212]

DataTarget

DataTargetType=ODBC
Server=Driver={Microsoft Access Driver (*.mdb)};Dbq=pta.mdb;DefaultDir=C:\Ferramentas\Papeis Trabalho Auditoria;Uid=Admin;Pwd=;
Database=
Password=
UserName=
TargetTable=Importacao
TransformationType=ADD
RejectedDelimiter=
RejectedQuote=
UseOracleDirectPath=False
CommitData=False
FireTriggers=False
KeepIdentity=False
KeepNulls=False
CheckConstraints=False
BatchSize=0
SQL_SEPARATOR=

Field=Conta
Mapping=Mapped To
MappedTo=[F2]
Calculated=
Format=
Default=
IfNull=Ignore
IfError=Set To Null
Key=False

Field=Nome Conta
Mapping=Mapped To
MappedTo=[F4]
Calculated=
Format=
Default=
IfNull=Ignore
IfError=Set To Null
Key=False

Field=Saldo
Mapping=Mapped To
MappedTo=[F6]
Calculated=
Format=
Default=
IfNull=Ignore
IfError=Set To Null
Key=False

Field=SS
Mapping=Calculated
MappedTo=[F6]
Calculated=StringToNumber(Replace('[F6]','.',''))
Format=
Default=
IfNull=Ignore
IfError=Set To Null
Key=False


SqlBefore


SqlAfter

Hello

Can you try putting brackets around expressions

(\"[CATEGORYID]\"==\"1\") || (\"[CATEGORYID]\"==\"2\")

John