Does anyone know if Alteryx supports .xbrl data formats or any workarounds in place as it doesn't seem to be one of the supported file type formats on designer.
Solved! Go to Solution.
@PeggyGithinji
as per best of my knowledge Alteryx does not support the .xbrl extension directly and you will need to run a python script to read that files.
@PeggyGithinji
you can try this python script
hope this helps
import pandas as pd
from xbrl import XBRLParser, GAAP, GAAPSerializer
# Load the XBRL file
xbrl_file = 'path_to_your_xbrl_file.xbrl'
parser = XBRLParser()
xbrl = parser.parse(open(xbrl_file))
# Use GAAP serializer to extract information
gaap_obj = GAAPSerializer(xbrl, 'http://fasb.org/us-gaap/2021-01-31')
data = gaap_obj.serialize()
# Convert to a DataFrame
df = pd.DataFrame(data)
# Save to CSV
df.to_csv('output.csv', index=False)
Thanks @Raj will look into embedding python and see how that works!
I believe XBRL is a syntax of XML and I'd look to processing it either in plain text or as XML. I would not use a python package which has not been updated in 8 years.