Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bfranc
Contributor
Contributor

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

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

Labels (1)
5 Replies
anat
Master
Master

can you change date format like 

SET DateFormat = 'DD/MM/YYYY';

then try like where col1=col2

PrashantSangle

Can you provide your script

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
bfranc
Contributor
Contributor
Author

[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
Contributor
Contributor
Author

[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

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂