excel file load problem

[#1]

hi masters.

i have an excel file and i need to join  on basis of account key.

plz find attached excel

Thanks

[Anonymous]

Is there a table in seperate sheets?

Let us say you have got tables in two seperate sheets and the common field name is Account_Key.

Load .... , account_key

from 1st sheet of the excel;

Load .... , account_key

from 2nd sheet of the excel;

At the end of the second load statement, QlikView will automatically join the two tables with the common column i.e account_key.

I hope this helps!

MultiView

[#3]

nothing was thre

what do u want just send me sample excel

[#4]

same excel file i h.ave data ,i need to map on basis of account key.same column i have account key more than 50 times.how could  i link

[Anonymous]

John

Your requirement is not at all clear. The best way is to upload a sample excel file (not like the one uploaded earlier). Help us understand your requirement to help you on how to achieve it.

Thanks

Regards

MultiView