topic Re: Latest Comment data from Comments Field in QlikView

Latest Comment data from Comments Field

gireesh1216 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Team,

I have a table like below. In comments field we are looking latest date comments. How to achieve this?

RAW DATA:

ID	Comments
1	<Gireesh> 10/30/2018 hello guys. <Suri> 10/25/2018 hello pa <nari> 10/23/2018 just started
2	<Suri> 10/25/2018 Start <nari>09/15/2018 end
3	<babu> 10/30/2018 Table Format'''''''''''''''''''''''''''''''''''123'''''''''''''''''''''' <nari> 9/10/2018 start

Comments

<Gireesh> 10/30/2018 hello guys.

<Suri> 10/25/2018 hello pa

<nari> 10/23/2018 just started

<Suri> 10/25/2018 Start

<nari>09/15/2018 end

<babu> 10/30/2018 Table Format'''''''''''''''''''''''''''''''''''123''''''''''''''''''''''

<nari> 9/10/2018 start

OUTPUT: (Looking only latest date comments)

dsharmaqv — Tue, 30 Oct 2018 07:31:26 GMT

try this if very 1st line will always shows the latest comments.

LOAD ID,
Comments,
SubField(Comments,'<',2) as Cmt
FROM
[https://community.qlik.com/thread/318279]
(html, codepage is 1252, embedded labels, table is @1);

gireesh1216 — Tue, 30 Oct 2018 09:04:49 GMT

Hello Sharma,

Below expression working fine.

=Subfield(Comments,chr(10),1)

Thanks for your replay