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: 
olguita2014
Creator
Creator

Separate records.

Hi,

Please help me!!!!..

I want to separate records from data field like capital letters and lowercase, How can I do this?... for example:

Data Field:

                          Names

Records:          ANA

                         Mary

                        

Then the result is:

                                             Names1 (capital letters)

                                              ANA

                                             Names2 (lowercase)

                                             Mary            

1 Solution

Accepted Solutions
luismadriz
Specialist
Specialist

En caso que quieras generar diferentes tablas:

Employees:

Load * Inline

  [Employee,

'Bob'

'MARK'

'Steve'

'Mary'

];

Cases:

  Load

    *,

    if(Upper(Employee)=Employee,1,0) as Uppercase

Resident Employees;

Drop Table Employees;

Names1:

NoConcatenate

Load Employee

Resident Cases

Where Uppercase = 1;

Names2:

NoConcatenate

Load Employee

Resident Cases

Where Uppercase = 0;

Drop Table Cases;

View solution in original post

3 Replies
luismadriz
Specialist
Specialist

Hola Olga,

How about this?

Employees:

Load * Inline

  [Employee,

'Bob'

'MARK'

'Steve'

'Mary'

];

Cases:

  Load 

    *,

    if(Upper(Employee)=Employee,Employee) as Uppercase,

    if(Upper(Employee)<>Employee,Employee) as Lowercase

  Resident Employees;

  Drop Table Employees;

Saludos

Luis

luismadriz
Specialist
Specialist

En caso que quieras generar diferentes tablas:

Employees:

Load * Inline

  [Employee,

'Bob'

'MARK'

'Steve'

'Mary'

];

Cases:

  Load

    *,

    if(Upper(Employee)=Employee,1,0) as Uppercase

Resident Employees;

Drop Table Employees;

Names1:

NoConcatenate

Load Employee

Resident Cases

Where Uppercase = 1;

Names2:

NoConcatenate

Load Employee

Resident Cases

Where Uppercase = 0;

Drop Table Cases;

luismadriz
Specialist
Specialist

Hi Olga, did you try the code I sent you? did it work for you? please let me know,

Regards,

Luis