cross tab tool output isn't aggregated

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

Output

Tips and Tricks

Best Practices

Accepted answers

davidskaife

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!

All comments

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

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703