Qlik Community

Ask a Question

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
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