Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

IDR data export for analysis

Summary:

Currently, you can download files in xml, xlsx, rtf, and a couple of other formats. In any case, when I attempted to convert this information into a data frame (in python), the results were illegible because the original formatting does not allow to extract information from the cells properly. Thus, without manual maniputlations to the xlsx file, there is no way to upload this data and analyse it, and I would really like to automate data extraction process.

Content (required):

Is there a way to reformat data (or get an SQL query to extract it separately) from the IDR reports so it would be more suitable for analysis using python or other tools?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!