Can Dixif reads multiple worksheets of excel workfbook?
Scenario
I have a excel workbook 1 which has worksheets a,b & c how do i setup processing group/dixif so that it reads data from all worksheets & insert/update data in my target table.
My setup works fine for worksheet a but cannot see data of worksheet b & c.
Thanks
Mav
Hi Mav,
It is not possible for DIXF to read data from multiple sheets for one single entity. In that case, you have to combine the information on one sheet in one table.
You can have multiple sheets for multiple entities.
I do not have multiple entities. The data has to go in same entity but data is spread across multiple sheets.
So looking for a solution which would allow to import data from multiple sheets into 1 entity .
Thanks
Mav
Hello, I hope the following blog will be useful -
docs.microsoft.com/.../excel-template-multiple
Data management in the application supports Microsoft Excel-based templates for data entities. These templates can contain one or more worksheets.
Mav,
I haven't tried this before. Will give it a try and let you know.
I am using Ax2012 R3 Feb update.
Are you sure sheet lookup would work ? Have you used it to consume multiple sheets of workfbook?
When i use sheet lookup in processing group form, it wont allow me to create another row for same entity , so really not sure how to use this feature?
Hi Mav,
You should be able to change the sheet lookup and use worksheets b & c as well. Is this not working for you?
Hi - what version are you using?
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
