Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i have 2 xl separeate sheets called
sales.xlsx and budget.xlsx
but in both sheets no of sheets same and sheet names also same and inside the sheet field names also same
now my req is i want create sample application to know the difference between these two xl sheets
in xl sheets i have sheet names like
summary
products
conditions
same sheet names i have in another xl sheet also
but inside the data may be different now i want know what is the different data between 2 sheets ?
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
i want to identify the unmatched data between the excels
1. You can use Qualify
2. then Unqualify the primary key
3. Left Join
Like this:
And you get this:
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
pls advice
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.
Not clear with your requirement(Unmatched Data). Plz. can you upload the XL files.
Thanks
when i am loading muliple shhets in same excel through for rach loop like
for each vsheets in 'sheet1','sheet2'
load
*
from ......
it is giving error like biff table cannot located file
and some times unknown file format specifier table
why?
I got this one
now i have loaded a multiple excel sheets through for each loop
now i want find the unmatched data between these two