Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mhappiee
Partner - Contributor III
Partner - Contributor III

Date Joining failing

Hi

 I have 3 tables  which has order time and extracted date from the same  and trying to join the 3 tables based on date with/With out master calendar but it is not properly joining , what might be the reason, can somebody help me trace where am i Going wrong?

 

Note: used floor , date , formats are same 

 

image.png

 

Regards,

Happiee

Labels (3)
3 Replies
West
Contributor
Contributor

You can't join these 3 tables just via "date". You need to specify the connections among order amount, past order id, and order No. There has to be a one-to-one relationship, or you will end up with a table like this.
mhappiee
Partner - Contributor III
Partner - Contributor III
Author

Hi,

Unfortunately I do not have any primary key to connect the data sets ,but trying to join them to compare the data sets side by side based on date . so there is no other possibility ?

 

Regards,

imhappiee

vinod22kv
Creator
Creator

Hi,

Please check the date field. if it has minits and seconds it is not posible to make joint use flore function to remove the time in the data and make the joint.

hope your format is like :dd-mm-yy hh:mm:ss" make this in to  dd-mm-yy It will work.  🙂