cross tab tool output isn't aggregated

[Moritz975]

Hi everyone, 
i have a problem with the coss tab tool. I want to transpose data from a table, which works fine if I click on the cross tab output. But one step further (Browse input) the data is split into different rows. Why is that? it shouldn't change without a new step in between right?! 

Thanks in advance for your help. 

Moritz 

[Felipe_Ribeir0]

Hi @Moritz975 

Yes, what you see on the output anchor of the cross tab tool must look like what you see on the browse tool if there is nothing between then.

Can you share this workflow with some dummy data so we can take a look at it?

[Moritz975]

No problem! Thank you for the fast response. 

[Felipe_Ribeir0]

@Moritz975 Can you share the 2 input files too? (or a dummy sample of it). 

[Moritz975]

sure! sorry!

[DavidSkaife · Accepted solution]

Hi @Moritz975 

You have two Cross Tab tools on the canvas, one over the top of the other, and the Browse tool is connected to the one at the bottom:

EDIT: actually, you have three tools altogether, two Cross Tabs and one Transpose!

[Felipe_Ribeir0]

Hi @Moritz975 

Yes, maybe you just did some copy and paste 😅

[Moritz975]

Oh no, haha! Thank you for your Help! A sign that shows overlapping tools would be helpful!