topic Re: Normalization in QlikView

Normalization

Wed, 24 Feb 2016 21:37:52 GMT

I have to make a Data Consistency i.e Normalization(one to one relation). Pls check below data format & suggest me

Vendor VendorID Country

BHARTI 001 India

BHARTI 002 USA

BHARTI 004 Singapore

E&Y 033 India

MID 033 Malaysia

IGATE 071 USA

V-IGATE 071 India

this format is within the same excel. I should not change the raw data. And it has to change dynamically when new vendor adds. when i select on country it is showing one to one relation but my dougth is vendor & vendorID is same for any country????

Re: Normalization

swuehl — Wed, 24 Feb 2016 22:18:57 GMT

Hard to tell a suggestion. You have used different Vendor names for the same VendorID as well as different VendorIDs for the same Vendor name.

Both might have reasons in your business.

You need to clarify for example:

- Can vendor name change over time? If so, how would you like to handle this? (Look into strategies for slowly changing dimensions)

- which name do you want to see e.g. for 71?

- Could different vendors have the same name? So they are only differentiated by VendorID? Maybe if you want to differentiate branches of a vendor, like local sub-organizations?

- If different vendors can't have same name, what is the leading field in your table? do you want to assign all BHARTI the same VendorID (which one)? Or change the name of two of the BHARTI (to which name)?

Before anyone can suggest a script code, you need to define the business logic.

Re: Normalization

Anonymous — Thu, 25 Feb 2016 06:20:37 GMT

Agreed with swuehl

You need to share the business logic for same...

If it is just about getting 1 ID for 1 Vendor.

Then decide, you want to assign a max(), min(), FirstValue(), Lastvalue() which you can do by taking resident of same