Both tools can:
UFT One - allows you to automate functional and regression testing for the widest range of applications and technologies can supports testing GUI, web, mobile or API applications.
UFT One includes a licence to UFT Developer.
If you don't need the additional support in UFT One, the UFT Developer is the tool you need.
We are using Smartbear TestComplete but tried Ranorex as well. It is capturing some parts of data but because the data is constantly changing the script is failing as it couldn't find that particular field. We then need to export this data to excel.
Is the dynamic data occurring in a web table? In that case, we can use the column headers as keys and fetch all elements inside the table and assign into a list/collection and then iterate them to find the data we require. It's regardless of tools, its just logic we build as a business with reusables.