Data Table Help Needed- Pulling data from file with no headers. New to RPA

Help
1

Hello all- I am fairly new to RPA and only working on my 3rd or 4th project since completing the training. Struggling to find a way to get the data I need in the right format. I have created my flow to open the Excel file in question, use the Data Scraping Wizard to scrape the data. The challenge then is getting it into a table that I can leverage for automating the rest of the process. Is someone able to point me in the right direction? Included is the Excel file and my xaml file up to this point. Any guidance would be greatly appreciated. RTM Standard Order Creation.xaml (40.2 KB)

1 Like
2

Hi Buddy @menfield

Welcome to UiPath community.

Great,
I have made few changes and added notes to the same. Kindly refer to the notes in this xaml that could help you to resolve this issue (zipped a folder, extract and edit you want to, buddy )
RTM Standard Order Creation.zip (5.9 KB)

Cheers…

3

Is that working buddy…@menfield

4

Great, thank you for the assist. I will give this a try in the morning and let you know if I run into more problems.

5

@Palaniyappan That appears to of worked and able to populate the data into a new file. I will continue on with the rest of the project and be sure to ask if I have further questions.

1 Like
6

Thats great …any time buddy @menfield
Cheers
Keep going

7

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