Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;
Is Dept in the same table in the script?
-Rob
I have to put '- ' after 4 digits from left. how to embed the code into this logic for style field
Ex: g9OH-ZW5369
Yes, Dept and style are both in the same table.
Hi Eric
I have to put '- ' after 4 digits from left. how to append this logic to the one you suggested
Ex: g9OH-ZW5369
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
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