HELLO,
several days in a week I received file with a name like this 20230105.csv, 20230118.csv, 20230201.csv, etc.
In each csv file there is file and in the first row i have the number of that file: 00001, 00002, 00003, etc.
In each file i have multiples row and 3 columns (A, B, C), but i need to add 2 more column: 1 with the name of the file and 1 with the number of that file, in order to identify every row.
I attached the workflow I already have, because i use a loop in order to work multiple file and create an unique csv.
Could you please tell me if are there nodes that helps me with this?
Thanks
do you need to use the File Reader Complex Format? I attached a (incomplete) Workflow which might give you an idea. This currently will not work in a setting for multiple files since the column names change over the iterations. But I just wanted to give you an idea to utilize the CSV Reader in case you could use it since it gives you the option to attach the file path to the output.
With it, you know the from file. At the Setting tabs, you can select the multi files options to bring all files from a folder, make it easier to bring all information at once.
Hello,
Unfortunally I have to use “Complex Format” because datas arrive in a TXT (I import raw data and after I splitt with “cell splitter node”) and for this reason i cannot select the option "add path available in csv reader node
You can also read .txt files with the CSV Reader, so this could work for your file structure as well and you could get rid of the File Reader and the Cell Splitter.
If you, despite the advice above, are still looking at the complex reader node: go to the Flow Variables tab of the node and in the white box of the file_selection/path, type a name and execute the node.
Use a variable to table column node and the file path will be available for processing thereafter.
THANKS! I already use this solution in order to group single files in a montly file.
The issue i cannot understand, how import the name of the file and the the code available in the first row of daily files, before to group in a montly file.
