Changing data structure (crosstab)

Hi,

I need help with restructuring some data.

The data schema I am working with has tables such as products, purchasers, sellers etc. I am trying to build a view to see the transactions clearly. The purchaser and seller information is kept in the attached sample data (current data sheet) and I would like to get it to the structure in the Desired Data sheet.

I have created a workflow to do this with a bunch of cross-tab tools and a join multiple tool (also attached) but it is working really slowly. Is there a more efficient way to do this?

Thanks!

Sample Workflow.yxmd

SampleData.xlsx

Datasets

Data Investigation

Accepted answers

DataNath

Hey @gkcekucuk, how does something like this look? The main part of the workflow stops at the Cross-Tab. The Dynamic Rename/Multi-Field Formula are just for a little bit of cleanup:

Edit: Added in an extra step to maintain the desired order of fields:

Change data structure.yxmd

All comments

DataNath

Hey @gkcekucuk, how does something like this look? The main part of the workflow stops at the Cross-Tab. The Dynamic Rename/Multi-Field Formula are just for a little bit of cleanup:

Edit: Added in an extra step to maintain the desired order of fields:

Change data structure.yxmd

Hamder83

Hi @gkcekucuk

Could it be something like this?

gkcekucuk sample flow.yxzp

gkcekucuk

Hi @DataNath . I implemented it and it worked! Thank you

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703