Forum Discussion
Can we manage to import multiple DTAB from a single Excel which will have multiple sheet of different DTABs.
Suppose I have two DTABs named A and B. I want to maintain a single Excel workbook containing two sheets named A and B. Whenever I need to import a DTAB, it should be retrieved from the workbook by matching the DTAB name with the corresponding sheet name.
Additionally, Is it possible to update all the Dtabs at once through a function by import facility. I have explored generic DTAB template but did not get logic how we import dtabs from excel.
@Tom Travis
3 Replies
The import process requires a CSV file, and an Excel spreadsheet with multiple tabs cannot be saved as a CSV file, so you would need to create code that automatically split each tab into its own CSV file before loading those in.
Thanks @Tom Travis for your time. Can you please tell me where I can find the Existing logic for import Facility I tried to find it but did not succeed.
It is in the RMA User Guide, Chapter 5, there is a section on the Import and Export of Decision Table data.
