topic Re: Append characters at the end of style field based on the selection made at the department field in QlikView

Append characters at the end of style field based on the selection made at the department field

Anuhyak1 — Sat, 16 Nov 2024 01:16:38 GMT

I have style and department fields . Dept is selection box which has values 512,232,789

STYLE

g9OHZW5369

q9TJTJ5258

t9NCGT5255

FPTKP0696M

If a style doesn't have a letter as the last character, add a letter based on the Dept #
                     Dept 512 = M (for M)
                     Dept 232 = P (for P)
                     Dept 789 = X (for x)

Example: g9OH-ZW5369 --> g9OH-ZW5369M because it comes from the M Dept

FPTKP0696M --> Don't append anything it has character at the end.

How to develop in the script

Re: Append characters at the end of style field based on the selection made at the department field

Ezirraffner — Fri, 14 Feb 2020 18:45:50 GMT

Hello @Anuhyak1 ,

Try this:

SET vDept = 512; temp: load * inline [ style, g9OHZW5369, q9TJTJ5258, t9NCGT5255, FPTKP0696M ]; temp2: load style&if(isnum(right(style,1)),if($(vDept)=512,'M',if($(vDept)=232,'P',if($(vDept)=789,'X'))),'') as new_style resident temp; drop table temp;

Re: Append characters at the end of style field based on the selection made at the department field

rwunderlich — Fri, 14 Feb 2020 19:09:35 GMT

Is Dept in the same table in the script?

-Rob

Re: Append characters at the end of style field based on the selection made at the department field

Anuhyak1 — Fri, 14 Feb 2020 19:10:39 GMT

I have to put '- ' after 4 digits from left. how to embed the code into this logic for style field

Ex: g9OH-ZW5369

Re: Append characters at the end of style field based on the selection made at the department field

Anuhyak1 — Fri, 14 Feb 2020 19:13:05 GMT

Yes, Dept and style are both in the same table.

Re: Append characters at the end of style field based on the selection made at the department field

Anuhyak1 — Fri, 14 Feb 2020 19:14:43 GMT

Hi Eric

I have to put '- ' after 4 digits from left. how to append this logic to the one you suggested

Ex: g9OH-ZW5369

Re: Append characters at the end of style field based on the selection made at the department field

rwunderlich — Fri, 14 Feb 2020 19:29:11 GMT

MapDept:
Mapping Load * Inline [
Dept, Suffix
512, M
232, P
789, X
];

Data:
Load
if(IsNum(Right(Style,1)),
STYLE & ApplyMap('MapDept', DEPT),
STYLE) as STYLE,
...the remainder of your load statement...

-Rob

Re: Append characters at the end of style field based on the selection made at the department field

Anuhyak1 — Tue, 18 Feb 2020 15:41:56 GMT

I have to put '- ' after 4 digits from left. how to append this logic to the one you suggested with Apply map.

Please help, some times H is repeating if i do logic =left(STYLE,4)&'-'& right(STYLE,len(STYLE)-4) or truncating if increase the number

Ex: g9OH-ZW5369