Dynamic Pivot

Hello,

Is it possible to make a pivot with dynamic fields.
I have a table with all different dates.
Can I make a pivot.

[SUPPLIER MAT#] --> [DELIVERY DATE] --> [QTY]

As I understand it, otherwise I need a fixed allocation.
With all the different dates an allocation is rather not possible.

Thomas
 

Sorry

I am very confused about your question.

Can you provide us with the source and target example as an Excel file, please?
EG this is what I have and that is what I am trying to achieve

Please keep it simple

Thank you Mike,

 

Thomas

Interesting challenge.

Still, nothing is impossible, we will have a look at it for you.

Hello Mike,

The plan would be this:
Customer sends file with his forecast (txt, xls, ...)

I then try to generate an "ETLsource" by default for all different file types.

Now our keyaccount should control the file and adjust it if necessary.

To make it easier for the keyaccount the date should be in one line so they can see the timeline of the Item "ETLtarget".

Then I convert it to an ERP readable version.

Sounds a bit complicated.
But I haven't thought of anything better yet

Thomas

Hello
We have created a working example for you
In order to make it easier to understand we included additional writers
All of them can be deleted except the result

The transformation consists of multiple steps
1 Create a sorted unique list of dates, it is also used to create a header
2 Join the data so that for every supplier material we have all possible dates
3 Calculate the sales list
4 Get the last value from the list above for every supplier material
5 Add header

Please follow the steps below

Download the attached zip file
unzip it into C:\Support\Cases\C0003
Open ats file
Run it