topic Re: Right returns nothing in App Development

Right returns nothing

Obsyky — Fri, 01 Jul 2022 10:19:07 GMT

Hello,

I have a problem with the right method which returns nothing.
To understand, here is my input table :

VALUE

A15

C85

G89

What I would like to find as a table after:

LETTER	NUMBER
A	15
B	0
C	85
F	1
G	89

For this use :

VALUELETTER: LOAD Left(VALUE,1) as LETTER, If(Len(VALUE) > 2,Right(VALUE,2),Right(VALUE,1)) as NUMBER Resident TABLE

With this code I get this :

LETTER	NUMBER
A	15
C	85
G	89

Why right returns nothing when the length is two ????

Thanks !

Re: Right returns nothing

sidhiq91 — Fri, 01 Jul 2022 10:50:31 GMT

@Obsyky Please see below. If it has resolved your issue, kindly like and accept as your resolution.

NoConcatenate
Temp:
Load * Inline [
VALUE
A15
B0
C85
F1
G89
];

NoConcatenate
Temp1:
Load *,
Left(VALUE,1) as Letter,
if(Len(VALUE)>0,Right(VALUE,len(VALUE)-1)) as Number
Resident Temp;
Drop table Temp;

Exit Script;

Re: Right returns nothing

Obsyky — Fri, 01 Jul 2022 11:51:24 GMT

That's almost it.

If I have "A1" and "A01" it turns me 01 for both but it's not the same for me 🙂

Re: Right returns nothing

sidhiq91 — Fri, 01 Jul 2022 12:18:51 GMT

@Obsyky sorry I did not get that. Did it not resolve your issue yet?

Re: Right returns nothing

Obsyky — Fri, 01 Jul 2022 12:27:51 GMT

I get this with your code :

I want this :

A01	A	01
A1	A	1

Re: Right returns nothing

Obsyky — Fri, 01 Jul 2022 12:59:07 GMT

The problem comes directly from Qlik which for him 01 = 1, except that not for me. I'll have to understand why

Re: Right returns nothing

sidhiq91 — Fri, 01 Jul 2022 13:16:29 GMT

@Obsyky Otherwise you are good with the solution right? If yes please accept it as a solution.

Re: Right returns nothing

Gui_Approbato — Fri, 01 Jul 2022 13:27:46 GMT

The function Keepchar would work for you as well:

VALUELETTER:
LOAD
Keepchar(VALUE,'ABCDEFGHIJKLMNOPQRSTUVWXYZ') as Letter,
Keepchar(VALUE,'0123456789') as Number
FROM Source...;

https://help.qlik.com/en-US/sense/May2022/Subsystems/Hub/Content/Sense_Hub/Scripting/StringFunctions/KeepChar.htm

Re: Right returns nothing

Obsyky — Fri, 01 Jul 2022 13:43:00 GMT

So my problem is not really solved 😞

Re: Right returns nothing

Obsyky — Fri, 01 Jul 2022 13:43:48 GMT

I can't use Keepchar because I have value like H0H for example

Re: Right returns nothing

Obsyky — Fri, 01 Jul 2022 13:54:34 GMT

Okay. I just added Text() so that it won't be considered as a number:

text(if(Len(VALUE)>0,Right(VALUE,len(VALUE)-1))) as Number

Re: Right returns nothing

MarcoWedel — Fri, 01 Jul 2022 21:00:49 GMT

You don't need the Right() function at all in this case:

table1: Load *, Left(VALUE,1) as LETTER, Text(Mid(VALUE,2)) as NUMBER Inline [ VALUE A1 A01 A15 B0 C85 F1 F01 G0 G1 G2 G01 G02 G89 ];