You’re offline. This is a read only version of the page.
30
Related to issue:
I think I understand the variables a lot better now and how to use it. I really appreciate the help with this! I have another variable that I am going to add which is %FileName%. Once, all the actions are completed and file is downloaded. File will be in download folder and file needs to be renamed and moved to particular destination. Then loop back through the same actions for all other JRPB account numbers to download, rename file, and move file. Until there is no more JRPB accounts to download.
The actions I took:
- Created new list %FileName%
- Then under the 1st nested action I use Add item to list action CurrentItem ['File Name'] to list %FileName%
(I had to keep space in order for PAD to read column name and it worked!)
See example of data below.
| Client Code | Account Number | File Name |
| JRPB | 1234 | ABCD |
| JRPB | 5678 | EFGH |
| JRPB | 1111 | IJKL |
| JRPB | 2222 | MNOP |
Currently the first account number and file is renamed and moved to folder. Which is perfect! When actions loop back around for the second account number (5678) file is named ABCD again and doesn't move to designated folder since file name is already there. See actions below.
- I created another for each action for each file name. But currently when it runs, it doesn't go to the next file name on list.
I need account number 5678 when selected to name file EFGH. Need each file to be renamed from the corresponding account number that was downloaded. I did an exit loop because I didn't want it to loop until the first actions to download file is done.
The Exit loop is causing the problem of picking up the first file name every time.
You need to remove the exit loop.
All your actions (download, rename file, and move file) will need to be inside this loop.
Share
Report
All responses (
Answers (
