topic Date Joining failing in App Development

Date Joining failing

mhappiee — Sat, 16 Nov 2024 07:00:04 GMT

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

Regards,

Happiee

Re: Date Joining failing

West — Thu, 20 Dec 2018 06:53:53 GMT

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.

Re: Date Joining failing

mhappiee — Thu, 20 Dec 2018 07:03:44 GMT

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

Re: Date Joining failing

vinod22kv — Thu, 18 Apr 2019 13:46:10 GMT

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. 🙂