get latest data

[RAJA3]

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 · Accepted solution]

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