Sort Excel file with config file

Help
1

Hello to the community,

I have an assignment from an employer that requires me to automate a small project, what is it;

  • I have a config file that contains several contributors, the first sheet is a contributors with their ID, the second sheet is payment information that contains a column with colleagues who are in charge of some of the contributors.
    -I have an input document that is being upgraded every day (excel file)
    and I have to sort that input file in a single excel file for each colleague, especially in a single directory with a current date for each colleague.
    Can anyone help?

Thank you all

2

Buddy you can use sort datatable activity and pass the input of column name and datatable obtained from read range activity…
Cheers @Gagi77

3

Ok buddy, i will try now.
Thank you bro

1 Like
4

Great
Kindly try and let know if you face any issues buddy
Cheers @Gagi77

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.