SOLVED
Read file name for data output
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
henrygeorge
8 - Asteroid
‎01-15-2024
10:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi I am reading a directory of excel files with specific sheet name "ABC123"
The file names of these excel files are "ABC 2023Dec30.xlsx" and "CO 02-02-2021.xlsx"
Excel 1 in Folder - ABC 2023Dec30.xlsx
No of Cars | Item No | Person |
12 | 12312 | Alex |
Excel 2 in folder - CO 30-02-2021.xlsx
No of Cars | Item No | Person |
15 | 123131 | Mer |
How do i output this data in these two files in a union (they both have same headers in the specific sheet "ABC123" starting from the 3rd row) and take the date as one of the outputs?
Desired Output :
No of Cars | Item No | Person | Date |
12 | 12312 | Alex | 30-12-2023 |
15 | 123131 | Mer | 30-02-2021 |
Solved! Go to Solution.
Labels:
- Labels:
- Designer Cloud
- Gallery
- Reporting
- Settings
2 REPLIES 2
jrgo
14 - Magnetar
‎01-15-2024
10:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not sure if this is what you're asking, but there's an option in the Input options to "Output File Name as Field".
grazitti_sapna
17 - Castor
‎01-15-2024
11:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have made Workflow for your Problem. Please Check.
If it works Kindly accept it as Solution.
Thanks
Sapna Gupta
![](/skins/images/A29875142F332EEF75F19ED75711F41B/responsive_peak/images/icon_anonymous_message.png)