topic Re: How to change my data in QlikView

How to change my data

Fri, 23 Sep 2016 19:27:19 GMT

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.

Re: How to change my data

sunny_talwar — Fri, 23 Sep 2016 22:51:45 GMT

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

Re: How to change my data

el_aprendiz111 — Fri, 23 Sep 2016 22:58:30 GMT

LOAD *,

Left(PERSONGROUP,2) AS PERSONGROUP_2

FROM

[..\..\ROUTE_BSE]

Re: How to change my data

soloeeeoff — Mon, 26 Sep 2016 07:11:11 GMT

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.