Transpose Crosstab

[gmamtani]

Hi All,

I have a raw data set, very unorganized file and I am aiming to create a flat file out of it for modeling purpose. However, I tried creating the workflow using Transform and Crosstab macros and I am stuck. It would be great if I can get some help from the experts.

I have attached the example for the input and the output. 

Thanks in anticipation.

Regards

G

[geraldo · Accepted solution]

@gmamtani 

Here's an example workflow

[gmamtani]

Hi Geraldo,

Thanks a lot for sharing the solutions. I am not able to see the values in the output. I have attached the screenshot of the output.

Many thanks.

Regards

G

[geraldo · Accepted solution]

@gmamtani 

sorry, when I put the select tool I didn't correct the columns. Check as it is in the print.

[gmamtani]

Great!!

Thanks Geraldo for sharing the solution. 

You made my work really easy, I was stuck with this for a couple of days. 

Thanks again :)

[gmamtani]

@geraldo 

Just one question. 

When I loaded the real raw data in this workflow, I could only see the data for the fist company. The data for the other companies is not reflecting. What should I do ?

Thanks

G

[geraldo]

@gmamtani 

You would need to send or post a printout of the spreadsheet with 3 records to verify that the location we extracted the company was ideal.

[gmamtani]

@geraldo 

Okay, sure. 

I have posted the dummy data of 4 companies. 

[geraldo · Accepted solution]

@gmamtani 

New Workflow

[gmamtani]

@geraldo 

Thanks for the updated workflow. 

I will run it with the complete dataset.  If I have any questions I will connect with you. 

Many Thanks :)