topic Re: How Load data Where (condition) Two columns are the same value each row? in Connectivity & Data Prep

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

bfranc — Mon, 17 Jan 2022 03:44:15 GMT

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

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

anat — Mon, 17 Jan 2022 04:22:00 GMT

can you change date format like

SET DateFormat = 'DD/MM/YYYY';

then try like where col1=col2

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

PrashantSangle — Mon, 17 Jan 2022 05:47:50 GMT

Can you provide your script

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

bfranc — Wed, 19 Jan 2022 18:13:40 GMT

[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);

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

bfranc — Wed, 19 Jan 2022 18:15:05 GMT

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

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

PrashantSangle — Wed, 09 Feb 2022 06:40:13 GMT

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