Hi All,
I have 4 tables each with only 2 columns (except for one that has 3) and they all have in common a date/time field. I am trying to export all 4 tables together as one CSV file and to have the records matched together where they have the same date/time.
My tables are structured like so (which originally came from 4 individual CSV files):
So as an exported CSV I would want the matching records (based on the date/time) to be part of the same record like so:
Time, heartrateValue, Intensity, minutesleepValue, minutesleepLogId, steps
3/01/2018 0:01, 45, 0, 1, 17396451215, 0
3/01/2018 0:02, 45, 0, 1, 17396451215, 0
etc.
A secondary issue is changing the date format to D/MM/YYYY from M/DD/YYYY. However, if I can get this CSV file export I can probably just loop through it in PHP and fix up the date format.
Thank you kindly for your assistance