Load an excel file's name and top most cell's data into an Oracle table

Question

Hello,

I would like to know a way in which we can load a file's name (Excel File) as data into one of the columns. In addition to that, while doing so, my file top most cell (Cell A1) would have some comments which I want to store as well into another column. Is there a way we can do it? Please advise.

Sample data of my excel sheet:

File Name: TEST_0308181033

ABCThis file contains test data as of 03/08/18  LVL1B1C1LVL2B2C2LVL3B3C3

Thanks!

LordNeilLord · Accepted Answer

Hey @timewaste

To load the file name as column in you data you can use "Output filename as field" in the input options:

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

LordNeilLord · Accepted Answer

To get the contents of A1 in to a column you can do something like this: