Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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');
just change the where condition to the below
where MATCH(date(Id),date('13/05/2007'));
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!
Perfect, thank you Manish
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.
Where Match(Date(Id),Date('13/05/2007'),'DD/MM/YYYY',Date('14/05/2007'),'DD/MM/YYYY');
