How Load data Where (condition) Two columns are the same value each row?

[bfranc]

Where Column1 =Column2 is not working! 

I'm trying create loading script with condition where each row of 2 columns is equal like:

Column 1  | Column 2

22/01/2022 | 22/01/2022

12/01/2022 | 11/01/2022

09/01/2022 | 09/01/2022

(after Script load)

Column 1  | Column 2

22/01/2022 | 22/01/2022

09/01/2022 | 09/01/2022

[anat]

can you change date format like 

SET DateFormat = 'DD/MM/YYYY';

then try like where col1=col2

[PrashantSangle]

Can you provide your script

[bfranc]

[firstbuy]:
LOAD
Id_user,
'09 - FirstBuy' AS Path,
Date_signup_user, //there are hours and minutes
Date_order, //there are hours and minutes
Id_order,
Status_order
FROM [lib://company/data/alldadosetl.qvd](qvd)
WHERE date(Date_signup_user,'DD/MM/YYYY') = date(Date_order,'DD/MM/YYYY');

//I tried too:
WHERE date(Date_signup_user) = date(Date_order);
 

[bfranc]

[firstbuy]:
LOAD
Id_user,
'09 - FirstBuy' AS Path,
Date_signup_user, //there are hours and minutes
Date_order, //there are hours and minutes
Id_order,
Status_order
FROM [lib://company/data/alldadosetl.qvd](qvd)
WHERE date(Date_signup_user,'DD/MM/YYYY') = date(Date_order,'DD/MM/YYYY');

//I tried too:
WHERE date(Date_signup_user) = date(Date_order);

[PrashantSangle]

Hi @bfranc 

[firstbuy]:
LOAD
Id_user,
'09 - FirstBuy' AS Path,
Date_signup_user, //there are hours and minutes
Date_order, //there are hours and minutes
Id_order,
Status_order
FROM [lib://company/data/alldadosetl.qvd](qvd)
WHERE Floor(date#(Date_signup_user,'DD/MM/YYYY') )= floor(date#(Date_order,'DD/MM/YYYY'));

Regards,

Prashant Sangle