Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

olguita2014
Contributor

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            

Tags (1)
1 Solution

Accepted Solutions
luismadriz
Valued Contributor

Re: Separate records.

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;

3 Replies
luismadriz
Valued Contributor

Re: Separate records.

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
Valued Contributor

Re: Separate records.

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
Valued Contributor

Re: Separate records.

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

Regards,

Luis