Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am facing Field not found - <Date Received>
when write the code :
QUALIFY "Date Sent",
"To (address)",
[Date Received],
"From (address)" ;
[Inbox]:
LOAD
IF (match(LEFT(Subject,3),'RE:', 'Re:', 're:','rE:'),MID(Subject,4),Subject)
as Subject,
"Date Sent",
"To (address)",
[Date Received],
"From (address)"
;
LOAD
Subject,
"Date Sent",
"To (address)",
date(date#("Date Received", 'mm/dd/yyyy hh:mm')) as [Date Received],
"From (address)"
FROM [lib://Data/Deloitte_inbox.csv]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
UNQUALIFY;
[MIN_INBOX]:
LOAD
Subject,
min([Date Received] ) as [First Time Received]
RESIDENT [Inbox]
GROUP BY
Subject ;
Hi,
You are using a QUALIFY statement, so you need to put "Inbox" before "Date Received" like this:
[MIN_INBOX]:
LOAD
Subject,
min([Inbox.Date Received] ) as [First Time Received]
RESIDENT [Inbox]
GROUP BY
Subject ;
Masaki
Hi,
You are using a QUALIFY statement, so you need to put "Inbox" before "Date Received" like this:
[MIN_INBOX]:
LOAD
Subject,
min([Inbox.Date Received] ) as [First Time Received]
RESIDENT [Inbox]
GROUP BY
Subject ;
Masaki