Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Split Data

Please anyone can help me to split data then check data:

Example:  2 y,3 m

               3 y, 4 m

then how to check.

Data attached,please check?

Please help any one?

1 Reply
Sokkorn
Master
Master

Hi,

Not sure this one you looking for

CodeNameDOBDOJGRADEDESIGNATIONDEPARTMENTLOCATIONM / FRelv. ExperienceF1F2
C010091Vinay Kumar Sharma20-Jul-7412-Feb-97G4Assistant Manager FinanceFINANCENCRM14 Y, 11 M14 Y11 M
C010967Pradeep Kumar9-May-8115-Nov-06G3Senior Accounts ExecutiveFINANCENCRM6 Y, 7 M6 Y7 M
C011162Devender Pal2-Jun-861-Jan-08G2Accounts ExecutiveFINANCENCRM8 Y, 4 M8 Y4 M

I added two field (F1 and F2). If this one is you looking for then try two ways to get this done:

1. Load

LOAD

     SubField([Relv. Experience],',',1) AS [F1],

     SubField([Relv. Experience],',',2) AS [F2],

2. Use expression

     SubField([Relv. Experience],',',1)

     SubField([Relv. Experience],',',2)

Regards,

Sokkorn