I have a use case where I need to use the data in Microsoft project file (MPP file). Tried converting it to an excel file and using it, but after converting because of merged rows, parsing data to cdt is not working. Any leads on how to resolve this?
Discussion posts and replies are publicly visible
Is this something that you're hoping to handle in a process, or is it an issue of getting the data out of excel one time for initial loading reasons? If it's the latter, you could always try copying the data into a new/clean excel file, or a CSV, etc.
I am trying to build a process to automate.