In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

SAP balance sheet to data cube

hahlhorn
5 - Atom

Hi there,

 

I often receive balance sheets exported from SAP  from different clients. (See one example below)

Until now, I processed the data with an VBA skript. Does anyone process similar data structures regularly and has an idea how to handle them? The goal is to create a data cube with one value column and 4 attributes (Account no., account, Reporting Unit no. & reporting unit)

Thanks in advance for your help!

Best regards!SAP_balance sheet_example.JPG

0 REPLIES 0
Labels
Top Solution Authors