Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
My IT have generated many table , for example :-
Sales order
AR
AP
GL
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
Paul you need to normalize your data. May be look here: Data Cleansing
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