You can use the QUALIFY for the Qlikview to prefix the column names with the Table(Sales & Budget) or you can rename the identical column names in the Sales.xlsx and budget.xlsx.
For QUALIFY, plz. take a look at the link below
Hi thanks for the reply
i have 2 separate xl sheets sales.xlsx and budget.xlsx
here both sheets contains shhet1 and sheet2
now i want compare between two separate xl sheets different data
dont think both sales and budget are in one xl sheet , both are different
still not understanding pls let me know
I do not understand your question. Do you have problems loading data from the two sheets within the the sales.xlsx and two sheets in budget.xlsx?
Go to Load Script ->Table Files-> Select your sales.xlsx sheet-> in File Wizard: Type in Tables drop down select Sheet1 and use embedded labels etc, finish.
Now you have loaded Sheet1 from Sales.xlsx
Same steps apply to all other sheets.