Is there a way to export different data sets into one file with multiple tabs (all exports in one report)?
Hello Monarch Community,
I have a question regarding potentially exporting different data sets into one file with multiple tabs. I know it is possible to run multiple exports at once and have the exported files appear individually in their destination folder, but I'm curious if there's a way to combine all of the exports into one report. This way instead of [x] number of individual files there would be one file with [x] number of tabs. It would also save me the time I'd have to spend re-naming each file and redirecting it into its correct folder.
Normally I would try and append and get all of the data on one template, but in this case the data sets don't overlap and an append is not practical.
Please let me know if this is not clear and I'll clarify further.
Thank you for your assistance!
Mark Rozny
Development Analyst
Ginosko Development Company
Novi MI
248-513-4900
------------------------------
Answers
-
Hi Mark,
let's say you have three exports, and you want one file but three tabs, one for each data source.
Configure the first export to overwrite for 'When file exist', and overwrite for 'When table exist'.
Configure subsequent exports to export into the same file as the first export, and select Append for 'When file exist', and overwrite for 'When table exist'.
When you run all three exports, the first one creates an Excel file with one tab, and the other two exports use the same Excel file, and create two more tabs.
Regards
Mo
------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 11-05-2019 11:33 AM
From: Mark Rozny
Subject: Is there a way to export different data sets into one file with multiple tabs (all exports in one report)?Hello Monarch Community,
I have a question regarding potentially exporting different data sets into one file with multiple tabs. I know it is possible to run multiple exports at once and have the exported files appear individually in their destination folder, but I'm curious if there's a way to combine all of the exports into one report. This way instead of [x] number of individual files there would be one file with [x] number of tabs. It would also save me the time I'd have to spend re-naming each file and redirecting it into its correct folder.Normally I would try and append and get all of the data on one template, but in this case the data sets don't overlap and an append is not practical.
Please let me know if this is not clear and I'll clarify further.
------------------------------
Thank you for your assistance!
Mark Rozny
Development Analyst
Ginosko Development Company
Novi MI
248-513-4900
------------------------------
"0 -
That worked. Thank you very much!Mahmoud said:Hi Mark,
let's say you have three exports, and you want one file but three tabs, one for each data source.
Configure the first export to overwrite for 'When file exist', and overwrite for 'When table exist'.
Configure subsequent exports to export into the same file as the first export, and select Append for 'When file exist', and overwrite for 'When table exist'.
When you run all three exports, the first one creates an Excel file with one tab, and the other two exports use the same Excel file, and create two more tabs.
Regards
Mo
------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
-------------------------------------------
Original Message:
Sent: 11-05-2019 11:33 AM
From: Mark Rozny
Subject: Is there a way to export different data sets into one file with multiple tabs (all exports in one report)?Hello Monarch Community,
I have a question regarding potentially exporting different data sets into one file with multiple tabs. I know it is possible to run multiple exports at once and have the exported files appear individually in their destination folder, but I'm curious if there's a way to combine all of the exports into one report. This way instead of [x] number of individual files there would be one file with [x] number of tabs. It would also save me the time I'd have to spend re-naming each file and redirecting it into its correct folder.Normally I would try and append and get all of the data on one template, but in this case the data sets don't overlap and an append is not practical.
Please let me know if this is not clear and I'll clarify further.
------------------------------
Thank you for your assistance!
Mark Rozny
Development Analyst
Ginosko Development Company
Novi MI
248-513-4900
------------------------------
"
Mark
------------------------------
Mark Rozny
Development Analyst
Ginosko Development Company
Novi MI
248-513-4900
------------------------------
-------------------------------------------
Original Message:
Sent: 11-05-2019 05:32 PM
From: Mahmoud Abdolrahim
Subject: Is there a way to export different data sets into one file with multiple tabs (all exports in one report)?
Hi Mark,
let's say you have three exports, and you want one file but three tabs, one for each data source.
Configure the first export to overwrite for 'When file exist', and overwrite for 'When table exist'.
Configure subsequent exports to export into the same file as the first export, and select Append for 'When file exist', and overwrite for 'When table exist'.
When you run all three exports, the first one creates an Excel file with one tab, and the other two exports use the same Excel file, and create two more tabs.
Regards
Mo
------------------------------
Mahmoud Abdolrahim
Senior Implementation & Integration Engineer
Datawatch Corporation
MA
(978) 935-3840
------------------------------
Original Message:
Sent: 11-05-2019 11:33 AM
From: Mark Rozny
Subject: Is there a way to export different data sets into one file with multiple tabs (all exports in one report)?Hello Monarch Community,
I have a question regarding potentially exporting different data sets into one file with multiple tabs. I know it is possible to run multiple exports at once and have the exported files appear individually in their destination folder, but I'm curious if there's a way to combine all of the exports into one report. This way instead of [x] number of individual files there would be one file with [x] number of tabs. It would also save me the time I'd have to spend re-naming each file and redirecting it into its correct folder.Normally I would try and append and get all of the data on one template, but in this case the data sets don't overlap and an append is not practical.
Please let me know if this is not clear and I'll clarify further.
------------------------------
Thank you for your assistance!
Mark Rozny
Development Analyst
Ginosko Development Company
Novi MI
248-513-4900
------------------------------
"0
Altair Employee