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

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.

1 Solution

Accepted Solutions
sunny_talwar

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
sunny_talwar

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

el_aprendiz111
Specialist
Specialist

Hi

LOAD *,

Left(PERSONGROUP,2) AS PERSONGROUP_2

FROM

[..\..\ROUTE_BSE]

soloeeeoff
Contributor III
Contributor III

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.