Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Prepare data from SAP export

ulrich_schumann
8 - Asteroid

Hi all,

we have a regular SAP Export where we have data grouped into sections.

- a first line starts with the Purchase Order number

- then 1 to N lines will follow with the Order Position and the Purchase details

- then further Purchase Order number

- followed by further Purchase Order Positions

 

How can I combine this Purchase Order number with the following Purchase Order Positions?

 

Example

Order number 1234

POS 10 - order amount - order date

POS 20 - order amount - order date

Order number 5678

POS 10 - Order amount - order date

...

 

Any ideas?

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus

 

@ulrich_schumann

 

I would consider using the DVS ACS-SAP Connector :)  a shameless plug.

 

By use of a multi-row formula, you can find rows containing the Order Number and create a new column.  Here is the formula that I used:

IIF(contains([Description],'Order number'),
ToNumber(GetWord([Description], 2)),
[Row-1:Order Number])

It will create a number by finding the third word (get word function starts with word 0) when the term, "Order Number" is found.  If it isn't found, then it uses the Order_Number from the prior row.

 

Screen Shot 2017-01-24 at 9.34.56 AM.png

 

I hope that this helps you.

 

Cheers,

Mark

 

 

 

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels