Help using RPA Design Studio: getting tabled data from pdf

[DLHill]

Hi

I am doing the core skills course on RPA Hub on now learning BUT I don't have office. (The course uses the example of creating a bot to enter data from an excel file into a security-badge-creator windows app. I have looked for alternative way to structure the data (xml, json) as xls won't work but could not find how to read an xml file to get the data out. So I settled on PDF because there is an example in the studio.

However I am struggling with understanding how to loop through the 3 lines of delimited data so I can feed each line into the windows app and create a badge for each person.

Attached screenshot is as far as I got, and its wrong as there is an ovbious missing step but if I add a for loop I can't see how to get a collection that the for loop wants. Please help! 

Thanks

Debbie

[DLHill · Accepted solution]

Did it! I saved the data as a table in a pdf:

And then I used the table connector. 

I'll add more detail later in case that helps anyone.