Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one folder and in that folder have multiple .txt files with same or different name and my user will create one or more file every day.
So what I want is whatever user create file in that folder I need to automatically fetch and reload the files from that folder .
Folder Name is :"Test for txt"
and for file names please find the screenshot.
Thanks
Prashant
Hi Anbu,
This Is for only one excel file what about another excel files that I want to load within a one reload.
Thanks
Prashant
Hi,
I want to load multiple excels sheets in a single load.
Thanks
Hi Jagan,
How to merge all txt file into one file and how to bifurcate to this with row id with each line.
Thanks
HI,
Try like this
TableName:
LOAD
*,
RecNo() AS RowNum,
FileName() AS FileName
FROM *.txt (txt);
Hope this helps you.
Regards,
Jagan.
Prashant,
Have a look at this:
loop through to load all files from a folder and its subfolders?
Cheers,
Antoine
Temp:
Load * From *.Txt(Txt);
Final:
NoConcatenate
Load *,RecNo() As RowId Resident Temp;
Drop Table Temp;