topic Re: adding sufixes in QlikView

adding sufixes

Wed, 25 Nov 2020 16:16:04 GMT

hi,

i have few values in list box as below:

Names
India
Bangalore
Cochin
India
Hyderabad
Pune
Mumbai
Pune
Mumbai

as seen in the list box, there are duplicates like india, pune and mumbai so i need only these three names to be suffixed by India_S, Pune_S, and Mumbai_S

so my list box will be like this :

Names
India
Bangalore
Cochin
India_S
Hyderabad
Pune
Mumbai
Pune_S
Mumbai_S

please help

Regards

srujana

Re: adding sufixes

sunny_talwar — Mon, 12 Dec 2016 15:45:43 GMT

So the second instances of India should be renamed to India_S? how about the third or 4th instance?

Re: adding sufixes

Anonymous — Mon, 12 Dec 2016 16:07:10 GMT

Hi,

like this?

DATA:

LOAD * Inline [

CITTA

India

Bangalore

Cochin

India

Hyderabad

Pune

Mumbai

Pune

Mumbai

];

NoConcatenate

DATA_2:

LOAD

CITTA

Resident DATA

Order BY CITTA;

DROP Table DATA;

NoConcatenate

DATA_3:

LOAD

CITTA,

IF(Previous(CITTA)=CITTA, CITTA&'_S', CITTA) AS CITTA_NEW

Resident DATA_2;

drop Table DATA_2;

Re: adding sufixes

Mon, 12 Dec 2016 16:08:27 GMT

no i dont have 3rd and 4th instance lie that..they r repeating twice only.....

Re: adding sufixes

marcus_sommer — Mon, 12 Dec 2016 16:12:04 GMT

Perhaps it's better to remove the duplications maybe per mapping.

- Marcus

Re: adding sufixes

Mon, 12 Dec 2016 16:17:07 GMT

i cant remove the duplicates as i need to show like that. and i cant use an inline load as well. as i have only these three names duplciate and i need to add suffix _S . Is there any expression can we write anything.

Re: adding sufixes

Anonymous — Mon, 12 Dec 2016 16:19:54 GMT

I use an inline because I don't have your data source...

Do you need an expression for the front end?

Re: adding sufixes

marcus_sommer — Mon, 12 Dec 2016 16:24:23 GMT

With removing the duplications within the listbox wasn't meant to remove the data behind them else only to clean the listbox-field. Normally there shouldn't be such duplications - and even if you want to keep them you will need why they exists and which from these values should be flagged with an addtional 'S' to find a stable solution.

- Marcus

Re: adding sufixes

MarcoWedel — Mon, 12 Dec 2016 22:09:54 GMT

Hi,

maybe one solution could be:

LOAD Names&If(Exists(Names),'_S') as Names
FROM [https://community.qlik.com/thread/243075] (html, codepage is 1252, embedded labels, table is @1);

(you would replace the inline load with your actual load statement)

hope this helps

regards

Marco

Re: adding sufixes

Tue, 13 Dec 2016 04:11:00 GMT

thank u for helping me.

the duplicates are coming from say for example i have a reqwuirement like:

if (flag = 'XYZ', then append _S to India, Pune and Mumbai)

so how can i achieve this on the front end side.

Re: adding sufixes

MarcoWedel — Wed, 14 Dec 2016 22:39:04 GMT

Hi,

maybe like this:

=Aggr(Names&If(RowNo()>1,'_S'),Names,ID)

hope this helps

regards

Marco