Solved: Re: get latest data - Qlik Community

RAJA3 · ‎2022-05-17

HI,

I'm new to Qlik Family.

I have a scenario - I need to get the latest values.

Please note, if any new data comes - it will be separated by comma and inserted.(it should be the last value as the latest value)

id	value
a	a1
b	b1,b2,b3
c	c1,c2,cc3
d	d1,d2,ddd3

Required output:

id	value
a	a1
b	b3
c	cc3
d	ddd3

Thanks In advance!

vchuprina · ‎2022-05-17

Hi,

You can use subfield function, see example below:

DATA:
LOAD
     id,
     value,
     SubField(value, ',', -1) AS newvalue;
LOAD * Inline[
id; value
a;   a1
b;   b1,b2,b3
c;   c1,c2,cc3
d;   d1,d2,ddd3
]
(delimiter is ';');

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

View solution in original post

vchuprina · ‎2022-05-17

Hi,

You can use subfield function, see example below:

DATA:
LOAD
     id,
     value,
     SubField(value, ',', -1) AS newvalue;
LOAD * Inline[
id; value
a;   a1
b;   b1,b2,b3
c;   c1,c2,cc3
d;   d1,d2,ddd3
]
(delimiter is ';');

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

get latest data

Script