In attached file i have populated missing data but there are two problems with the output
1) count is showing 4204. Although it should be 115 as it does with distinct count. I don't understand where this 4204 comes from although i have removed all data from final load?
2) Final date format is dd/mm/yyyy hh:mm:ss but i want this to format in script as dd/mm/yyyy. I tried Date(Date#) but its not working. I can work around this in front end but i want to do this in script.