Match with numbers

[fkeuroglian]

Hi expert,

i am using the function match with numbers(or dates) and not respond, if i try using text work ok

i want to load information only for some specific dates that i will pass in a .txt later

thank you a lot , i attached a qvw and an excel where i try

Fernando

[MK_QSL]

Directory;

LOAD Id,

     [Compra 1] as Compra,

     $

FROM

[Gastos - Copy.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Match(Date(Id),Date('13/05/2007'),'DD/MM/YYYY');

[maleksafa]

just change the where condition to the below

where MATCH(date(Id),date('13/05/2007'));

[fkeuroglian]

Perfect, thank you Malek

if i wan to put more than one value? or a list that i have in a variable?

where MATCH(date(Id),date('13/05/2007','14/05/2007'));

how would be? thank you a lot!

[fkeuroglian]

Perfect, thank you Manish

if i wan to put more than one value? or a list that i have in a variable?

where MATCH(date(Id),date('13/05/2007','14/05/2007'));

how would be? thank you a lot!

[maleksafa]

simply add them like that

where MATCH(date(Id),date('13/05/2007'),date('14/05/2007'));

in the match function the first parameter is the lookup value and all the other parameters from 1 to N are the values to search for.

[MK_QSL]

Directory;

LOAD Id,

     [Compra 1] as Compra,

     $

FROM

[Gastos - Copy.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where Match(Date(Id),Date('13/05/2007'),'DD/MM/YYYY',Date('14/05/2007'),'DD/MM/YYYY');