How to Handle Complex Data Transformations in UiPath?

[Success_Path_Academy (UPath Botcurator)]

I’m currently working on a process that involves complex data transformations — such as merging multiple data tables, cleaning inconsistent data, and converting nested JSON structures into usable tabular formats.

I’d love to hear how other developers approach this kind of challenge.
Specifically:
• What’s your go-to method for handling multi-level or hierarchical data (like JSON or XML)?
• How do you perform bulk data cleaning or reshaping efficiently in UiPath?
• Do you prefer using LINQ queries, Invoke Code activities, or purely UiPath activities for transformations?
• Any tips for maintaining performance and readability when working with large datasets?

If you have sample workflows, activity recommendations, or best practices — please share!

[Anil_G (Anil Gorthi)]

@Success_Path_Academy

there are deserialize activities both for json and xml

if json array then can be converted to datatable directly

linq is preferred based on what kind of transformations

for advanced linq,basic and data which is cleaned UiPath activities

invoke code if any updates are to be made to same datatable with lrger numebr of rows or expressions if they support

cheers