How to change my data

[#1]

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.

[sunny_talwar · Accepted solution]

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

[el_aprendiz111]

Hi

LOAD *,

Left(PERSONGROUP,2) AS PERSONGROUP_2

FROM

[..\..\ROUTE_BSE]

[soloeeeoff]

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.