Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have field value called
IBM-CONTENT-NAVIGATOR |
IBM-CONTENT-NAVIGATOR-CONT |
IBM-CONTENT-NAVIGATOR-DEV |
IBM-CONTENT-NAVIGATOR-UAT |
I need the value like
IBM-CONTENT-NAVIGATOR |
I have wriiten the logic in qlik as
UPPER(IF
(SubField(Depedent_CI_NAME,'-',-1) = 'CONT', SubField(Depedent_CI_NAME,'-CONT',1),
IF
(SubField(Depedent_CI_NAME,'-',-1) = 'DEV', SubField(Depedent_CI_NAME,'-DEV',1) ,
IF
(SubField(Depedent_CI_NAME,'-',-1) = 'UAT', SubField(Depedent_CI_NAME,'-UAT',1),Depedent_CI_NAME)))) as Depedent_CI_NAMES
I
I am not getting proper result
I am geeting like IBM
CAn anyone please help
maybe this:
subfield(YOURFIELD,'-',1)&'-'&subfield(YOURFIELD,'-',2)&'-'&subfield(YOURFIELD,'-',3) as new_Field
x:
Load
IF(SubStringCount(A,'-')=3,Left(A,Index(A,'-',3)-1),A) AS AA,
A;
Load * Inline
[
A
IBM-CONTENT-NAVIGATOR
IBM-CONTENT-NAVIGATOR-CONT
IBM-CONTENT-NAVIGATOR-DEV
IBM-CONTENT-NAVIGATOR-UAT
];
It is working only for that particular value(IBM-CONTENT) only.
i have thousands of fields in which -CONT will come last, i need to remove the last 4/3 letters which are ending with
-CONT,-DEV and -UAT .
i have thousands of names lke this
example1:
3DAYS-BPM-CONT == i want to remove CONT here
example2:
if 2FA-STRONG-AUTHENTICATION-HBFR-DEV id there i want to remove DEV here
Can anyone please help.
i have written like this
UPPER(IF
(SubField(Depedent_CI_NAME,'-',-1) = 'CONT', SubField(Depedent_CI_NAME,'-CONT',1),
IF
(SubField(Depedent_CI_NAME,'-',-1) = 'DEV', SubField(Depedent_CI_NAME,'-DEV',1) ,
IF
(SubField(Depedent_CI_NAME,'-',-1) = 'UAT', SubField(Depedent_CI_NAME,'-UAT',1),Depedent_CI_NAME)))) as Depedent_CI_NAMES
But
May be try
x:
Load
If(Match(SubField(A,'-',-1),'DEV','CONT','UAT')>0,Left(A,Index(A,'-',-1)-1),A) As AA,
A;
Load * Inline
[
A
IBM-CONTENT-NAVIGATOR
IBM-CONTENT-NAVIGATOR-CONT
IBM-CONTENT-NAVIGATOR-DEV
IBM-CONTENT-NAVIGATOR-UAT
2FA-STRONG-AUTHENTICATION-HBFR-DEV
3DAYS-BPM-CONT
];
HI
By my logic
=PICK( MATCH(SubField(UPPER(Depedent_CI_NAME),'-',-1), 'DEV', 'UAT','CONT'),
SubField(Depedent_CI_NAME,'-DEV'),
SubField(Depedent_CI_NAME,'-UAT'),
SubField(Depedent_CI_NAME,'-CONT'), Depedent_CI_NAME)
example:
ACCESS-CONTROL-CHECK-IN-SYSTEM-ITALY-CONT
i am getting the name as ACCESS only
why because it is taking ACCESS-CONTROL and here itslf it is taking as ACCESS
but i need as ACCESS-CONTROL-CHECK-IN-SYSTEM-ITALY
Hi try the below one, it will work
temp:
load * ,
if(Right(AA,5)='CONT1' , Replace (AA,'-CONT1',''),
if(Right(AA,3)='DEV', Replace(AA,'-DEV',''),
if(Right(AA,3)='UAT', Replace(AA,'-UAT',''),
AA))) as AAA
;
Load
if(Right(A,4)='CONT', A&'1',A) as AA ;
Load * Inline [
A
IBM-CONTENT-NAVIGATOR
IBM-CONTENT-NAVIGATOR-CONT
IBM-CONTENT-NAVIGATOR-DEV
IBM-CONTENT-NAVIGATOR-UAT
3DAYS-BPM-CONT
2FA-STRONG-AUTHENTICATION-HBFR-DEV
];
hi sasi
thnks for help.