Discussion board where members can get started with Qlik Sense.
I want to export a single row for each IssueKey based on the latest entry of TaskDate column that i have in my code.
I am combining 2 spreadsheet using left join and the output that i get on that i want to apply filter to get a single record for the multiple entries that i am getting for a given IssueKey.
Please find below the codes for reference.
Also please find attached the screenshot of the output that i am getting.
"Old Meter Id" as Old_Meter,
"Old Lce Id" as Old_LCE,
"Property Id" as PropertyID,
"TWSMOC Id" as IssueKey,
"Job Ref#" as JobRef,
FROM [lib://Field Investigation/Master sheet1.csv]
(txt, codepage is 28591, embedded labels, delimiter is ',', msq);
Filename() as TWMFilename,
DATE(DATE#(LEFT(RIGHT(Filename(),10),6),'DDMMYY'),'DD/MM/YYYY') as TWMFiledate,
"Job Reference" as JobRef,
"Installation Completed Comments" as Operative_Comments,
"Job Sent to TW",
//DATE(TaskDate, 'DD/MM/YYYY') as TaskDates,
"Meter Serial No",
"Meter Serial Number" as Old_Meter,
"Old LCE Serial Number",
"Old LCE Reader Serial Number",
"CIS Property Reference: CIS Property Reference" as PropertyID,
"Serial No: Serial Number" as New_Meter,
"LCE Reader Serial No" as New_LCE
FROM [lib://Field Investigation/TWMReport_030418.csv]
max(TaskDates) as MaxTaskDate
Group by IssueKey;
Your screenshot is just a blank white page... could you please upload a new one?
I have re-attached the screenshot in my post. Please see below the screenshot for your reference.
Thanks in advance.
What you did will append the MaxTaskDate to every record in your original file; now if you want to filter it.
LOAD * RESIDENT F1 WHERE TaskDate = MaxTaskDate;
Thank you sooo much. It worked