Cleansing data from SAP into a useable format

[ginda8]

Hi  everyone,

I am hoping someone will be able to help me or has faced this problem before. I have this data from SAP. It is not in a user friendly format as i would like it stacked in a proper spreadsheet for further analysis however unsure how to proceed. please see below.

Original:

Desired format:

I have attached a copy of the extracted excel file .

Many thanks for any assistance in advance.

[Matthew]

does SAP have any other export formats? even just a text file?

[ginda8]

Yes i can extract as a text file 

[Matthew]

that might be a better candidate for parsing data than this excel file

[ginda8]

Thanks Matthew, I have extracted in the text file but not sure it helps

[Amol_Telore]

@ginda8 I believe you are using ACS connectors for reading data from SAP. You can try below options to solve this problem

1. I see that you do not need all the fields coming SAP report. Instead only few selective fields are needed. In this case, Open that report in SAP GUI application (front end) and create a layout with required fields only. You won't be changing the layout of original report. You are just creating another visualization view for that report. After layout is created, you can specify this layout ACS connectors. I hope by doing this you might get all the required fields in one single row as we are removing unnecessary fields.
2. You can use ACS file tool to read and parse data from SAP extract.

If above two options doesn't work, can you share your extract in txt file. I would like to give it try from my side. Thanks.

[Simon_TS]

@ginda8  It looks like you want to extract data from a SAP Report into an Alteryx workfow. Theobald Software has a dedicated component called Xtract Report for exactly this. It makes it very easy to consume SAP data in a structured format in an automated way. You can check out more details here: https://help.theobald-software.com/en/xtract-for-alteryx/reports . There are also connectors for even more SAP sources such as SAP Queries, Tables, T-Codes, BAPIs, etc. A free trial is available on their homepage