Forum Discussion

AFra's avatar
AFra
Icon for Helper III rankHelper III
5 years ago
Solved

Importe row number from an excel file

Hi all,    I have imported a folder with 150 excel files. I would like to import also the ROW NUMBER for each line of each excel file, so that I get an index column such as :  EXCEL FILE ROW N...
Need Help
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
5 years ago

Hi AFra ,

yes, that's not the right place to add the index column. 

It has to sit in the function that your'e executing in the step before:

 

Find out where it comes from and add the index in there.

AFra's avatar
AFra
Icon for Helper III rankHelper III
5 years ago

Thanks a lot ImkeFfor your help, but I don't understand what you mean by "it has to sit it the function". I tried to execute the index function before in the steps, but it doesn't change anything. would you be kind enough to show me how to do it? here's a sample of the files (they should be in a folder) : https://we.tl/t-xJiXZIVMvt

    • AFra's avatar
      AFra
      Icon for Helper III rankHelper III
      5 years ago

      Thanks a 10000 times!