Is there a way to extract a file name in the data reader ETL?
Hi Board Community!
I am working on creating an ETL logic to dynamically extract months to a correct fiscal year. The complication comes in because there are some of the future years that need to roll up to the year end of the particular (past) year. I know that there is the formula in excel that allows you to extract the file path in a cell ( =Cell("filename") ). I tried using it in the ETL, but it didn't work. I am curious to see if there is an alternative way on how we can extract the file name of the connected file in the data reader?
Thank you in advance for your responses!
Accepted Answers
-
Hi Anastasia,
The only potential solution I can think of for this one, is to do this at the time of file creation before the file comes into Board. At this point you could add a column to the file and generate the filename into this column using the formula above. I am not aware of solution to do this in Board.
Kind regards,
Gary
0 -
Hi Anastasia,
Gary is correct to my knowledge, the CELL() function isn't recognised on a flat file, if the file is being created by the customer then it would be best to do this at that stage. If Board is creating it then there may be some kind of solution to populate a column with the file name as text, but my guess is it's the former.
Thanks
Scott
0
Answers
-
Thank you for your input Gary and Scott!
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP