Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
rish_sai
Contributor III
Contributor III

how to split fullname into first name and last name

Hi,

I have issues how to split full name into first name and last name and coma is there in between first name and last name

for example:

full name                           first name                   last name

Jose , alex                             jose                       alex       

Ha, Rishi                             Ha                            Rishi                  

Siri ,  kanth                         Siri                          kanth

1 Solution

Accepted Solutions
maxgro
MVP
MVP

with subfield function

Source:

load * inline [

full name

Jose , alex

Ha, Rishi

Siri ,  kanth

] (delimiter is '@');

Left Join (Source)

load

  [full name],

  SubField([full name], ',', 1) as [first name],

  SubField([full name], ',', 2) as [last name]

Resident Source;

View solution in original post

2 Replies
maxgro
MVP
MVP

with subfield function

Source:

load * inline [

full name

Jose , alex

Ha, Rishi

Siri ,  kanth

] (delimiter is '@');

Left Join (Source)

load

  [full name],

  SubField([full name], ',', 1) as [first name],

  SubField([full name], ',', 2) as [last name]

Resident Source;

View solution in original post

MindaugasBacius
Partner
Partner

Use substring function:

LOAD [Full name]

  ,SubField([Full name], ',', 1) as [First name]

  ,SubField([Full name], ',', 2) as [Last name]

INLINE [

    Full name

    "Jose, Alex"

    "Ha, Rishi"

    "Siri, Kanth"

];

Results as you required:

Screenshot_2.png