Alteryx and XBRL

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.

Datasets

Accepted answers

Raj

@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)

All comments

Raj

@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.

Raj

@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)

PeggyGithinji

Thanks @Raj will look into embedding python and see how that works!

apathetichell

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703