Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

How to change my data

So I have an excel sheet that is 500,000 rows by 30 columns large. "PERSONGROUP" is a column title with about 50-60 different entries. The problem is that several of these entries should be grouped together so that there are only 10-15 different entries (i.e. 'FAC', 'FAC1, 'FAC2' should all be called 'FAC', and 'ES', 'ESMGR', 'ES1' should all be called 'ES'). What is my best course of action? Should I go back and change all the data in the excel sheet (which would take a very long time), or is there some way I can edit the script in qlikview to group or rename specific data? I am not a very experienced coder, so the simpler the answer the better.

Tags (2)
1 Solution

Accepted Solutions
Highlighted

Re: How to change my data

Try not to recreate multiple threads. Stefan already mentioned you to read Data Cleansing, try reading that and see if that helps

View solution in original post

3 Replies
Highlighted

Re: How to change my data

Try not to recreate multiple threads. Stefan already mentioned you to read Data Cleansing, try reading that and see if that helps

View solution in original post

Highlighted
el_aprendiz111
Valued Contributor

Re: How to change my data

Hi

LOAD *,

Left(PERSONGROUP,2) AS PERSONGROUP_2

FROM

[..\..\ROUTE_BSE]

Highlighted
soloeeeoff
New Contributor III

Re: How to change my data

Hi Jacob,

I am so glad to see you facing the same thing I faced.

It is possible to cleanse the data by using Mappings.

Try Mapping concept.

(If a sample data been given, can help you better )

Thanks.