topic Re: Subfield in QlikView

Subfield

mahendragaur — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I want to get the name from a column which contains either 'x' or 'X' character in between Name and Age. How can I get name using or functionality in SubField?

Mahendra X 22

Prasad x 55

Pranav

Mahendra x 11

Prasad X 54

Pranav

Re: Subfield

Anil_Babu_Samineni — Tue, 04 Apr 2017 10:36:12 GMT

What was the expected output here

Re: Subfield

Tue, 04 Apr 2017 10:36:39 GMT

hi ,

use subfield('fieldname','symbol(X)')

Regards,

Balakrishnan.R

Re: Subfield

mahendragaur — Tue, 04 Apr 2017 10:39:57 GMT

Expected Output:

Mahendra

Prasad

Pranav

Mahendra

Prasad

Pranav

Re: Subfield

vinieme12 — Tue, 04 Apr 2017 10:42:31 GMT

Try below

LOAD SubField(Name,if(findoneof(Name,'X'),' X ',' x '),1) as NAME,SubField(Name,if(findoneof(Name,'X'),' X ',' x '),2) as Age Inline [

Name

Mahendra X 22

Prasad x 55

Pranav

Mahendra x 11

Prasad X 54

Pranav

];

Re: Subfield

Anil_Babu_Samineni — Tue, 04 Apr 2017 10:42:38 GMT

Use this

LOAD SubField(Name,' ',1) as Name, RowNo() as ID Inline [

Name

Mahendra X 22

Prasad x 55

Pranav

Mahendra x 11

Prasad X 54

Pranav

];

Re: Subfield

annafuksa1 — Tue, 04 Apr 2017 10:42:40 GMT

try

SubField(YourField,' ',1)

Re: Subfield

vinieme12 — Tue, 04 Apr 2017 10:45:55 GMT

or Just This

LOAD subfield(Capitalize(Name),' X ',1) as Name Inline [

Name

Mahendra X 22

Prasad x 55

Pranav

Mahendra x 11

Prasad X 54

Pranav

];

Re: Subfield

gerry_hdm — Tue, 04 Apr 2017 10:50:01 GMT

you are work with uper

Load *,
upper(subfield( uppername , 'X' ,1)) as NameNew2
;
load
upper(Name) as uppername,
upper(subfield( Name , 'X' ,1)) as NameNew

inline [Name
hallo x 22
hallihallo
myname X 46
];
greetings gerry

Re: Subfield

mahendragaur — Tue, 04 Apr 2017 10:52:49 GMT

Thank you Buddy.

Re: Subfield

mahendragaur — Tue, 04 Apr 2017 11:07:37 GMT

Hi Vineeth,

What if there is no space between "Name and X" or "x and Age". It is not taking subfield in different column

MahendraX 22

Prasad x55

Pranav

Mahendra x 11

Prasad X 54

Pranav

Re: Subfield

vinieme12 — Tue, 04 Apr 2017 11:16:44 GMT

Try below

LOAD Capitalize(Trim(subfield(Upper(Name),'X',1))) as Name Inline [

Name

Mahendra X22

Prasadx 55

Pranav

Mahendrax 11

Prasad X54

Pranav

];

Re: Subfield

mahendragaur — Tue, 04 Apr 2017 11:36:52 GMT

Thank You So much once again.

Perfect answer...