sample data for Country, State, City, Address and Post code(ZIP Code

[bhavvibudagam]

Hi Experts,

Can any one please provide the sample data for Country, State, City, Address and Post code(ZIP Code).

I have one requirement in qlikview i need to match Address and Postcode with country.If it matches then its correct else wrong.

for that I need to derive one more new column for correct/Wrong.

Is theier any way to dervice the column like this.

For example country US if address is London then it need to show wrong.

Thanks in advance.

[devarasu07]

Hi,

Try to use Northwind sample data set, attached file has customer table and you can use that.

[bhavvibudagam]

Hi Devarasu,

Thanks for your reply. How to Import this mdb file into qlikview. I am not able to see the files once i have selected Table files.

Thanks,

[devarasu07]

Hi,

There are lot's of material available in web. just google it.

fyi,

Step1: