Download CVs based on major

hi
i have this task where i should download CVs of students in different majors and creating folders for each major…
my question is, when i use the IF statement saying that if the DT contains “major1” for example… download its CV in the next column.

attached image to make things clear

image

Hi!

That’s not a question… :thinking:

You should:

  • Read Excel data with Read Range activity
  • Use For Each Row activity to iterate through the data
  • Use an If activity to check the Major column
  • You could use a Path Exist acitivty to check if you have a folder for that major already
  • In case no folder exists, create one
  • Download the file for that row and put it in the respective folder

Happy automating

thank you :grinning_face_with_smiling_eyes:

1 Like

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