I have joined 2 excel files that have dates in them. Both follow the same structure but represent sept and oct file. I used tableau prep to union both the files think the dates will also get updated. instead of showing the updated dates its showing multiple dates.
7 answers
If you just want to show the Last ODO value for each Rego No then, start by unioning the files together like this:
Then we can create some calculated fields:
Last Date
// Latest date for each rego no
{FIXED [Rego No]: MAX([Last Odo Date])}
Odo
// Odo related to the latest date.
{FIXED [Rego No]: SUM(
IF [Last Odo Date]=[Last Date] THEN
[Last Odo]
END
)}
