topic excel file load problem in QlikView

excel file load problem

Mon, 21 Jan 2013 15:23:27 GMT

hi masters.

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

plz find attached excel

Thanks

Re: excel file load problem

Anonymous — Mon, 21 Jan 2013 15:55:08 GMT

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

Re: excel file load problem

Mon, 21 Jan 2013 15:57:52 GMT

nothing was thre

what do u want just send me sample excel

Re: excel file load problem

Mon, 21 Jan 2013 16:20:36 GMT

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

Re: excel file load problem

Anonymous — Mon, 21 Jan 2013 16:29:57 GMT

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