topic Re: How to handle COMPANY field name ? in QlikView

How to handle COMPANY field name ?

paulyeo11 — Sat, 07 Jan 2017 12:53:27 GMT

‌

Hi All

My IT have generated many table , for example :-

Sales order

Each of the above table , it have company field name , some of the company field length 25 , some 40. Meaning some company name not full.

My question is how should I handle this situation on diff length ?

In the pass I try to create different field name :-

COMPANY

company

Company_sales

As I worry if I use same name , all table will join the company and it become very complicated.

Now it is very messy.

Hope some one advise me.

Paul

Re: How to handle COMPANY field name ?

sunny_talwar — Sat, 07 Jan 2017 13:14:25 GMT

Paul you need to normalize your data. May be look here: Data Cleansing

Re: How to handle COMPANY field name ?

paulyeo11 — Sat, 07 Jan 2017 13:24:01 GMT

Hi Sunny

I read the article , I notice it is talk about value label . For example field name Country and value label for US write in many format , USA etc

Mine is in my date structure , I have few table , each table also have a country field, my question is should I create only one field name as COUNTRY ? Or should I create COUNTRY_AP , COUNTRY_AR

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804