Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all ,
Kindly i need to read from 2 excel sheet , each excel sheet has the target of each year .
The first excel sheet is name Target-2016 and the second is Target-2016 i am using this target on single KPI
How can i read these two sheet without concatenation since i am you going to add a target next year as well.
Thank you.
Hope you can help
Hi Mario,
You can use qualify to have both excel sheets.
Regards
Miguel del Valle
Hi Miguel ,
Can you clarify what you said please ? or any example ?
Thanks a lot
Hi Mario,
Your problem, If I´ve understood correctly, it´s that you have two origins with differents values but similar names.
Qualify change automatically names of fields. If you want to know more about it please read this document Do you Qualify?- How to use QUALIFY statement.
Regards
Miguel del Valle de Gracia