Transposing data Excel

More

3 years 5 months ago #22392 by Dj16122000

Replied by Dj16122000 on topic Transposing data Excel

Hi Peter,
I want to create a file with the pivot table as designed in the attached file.
I hope you can help me.

File Name: Designpivo...les.xlsx
File Size:10 KB

Attachments:

Please Log in or Create an account to join the conversation.

More

3 years 5 months ago #22393 by admin

Replied by admin on topic Transposing data Excel

Can you tell me where Locatie(location) is coming from?

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More

3 years 5 months ago #22394 by Dj16122000

Replied by Dj16122000 on topic Transposing data Excel

Hi Mike,
The locations are: VMarrew,Bodde, Bodde2A, OZW16,OZW22,GANTEL5 and LD

Please Log in or Create an account to join the conversation.

More

3 years 5 months ago #22395 by admin

Replied by admin on topic Transposing data Excel

I have created an example for you based on my understanding.

See attached zip file

Mike
ETL Architect

Attachments:

Please Log in or Create an account to join the conversation.

More

3 years 5 months ago #22397 by Dj16122000

Replied by Dj16122000 on topic Transposing data Excel

Thank you

Please Log in or Create an account to join the conversation.

More

3 years 5 months ago #22398 by Dj16122000

Replied by Dj16122000 on topic Transposing data Excel

When I open the file i don't see a transformatiion called example.
I only see my own transformations.
What's going wrong?

The following user(s) said Thank You: admin

Please Log in or Create an account to join the conversation.