Issue appending data after a cross tab

Hi - I am trying to append a 1x3 matrix to a 1x18 matrix after a cross tab. When I look at the output from the cross tab, I see 18 fields (which is correct), but when I look at the input on the next tab it says there are 4 fields (which is not correct).

If anyone can help me sort this out, I would be super grateful.

Thanks.

Image1.png

Image2.png

Transformation

Accepted answers

oly

Hi @alteryxworker ,

you had two transpose tools one over the other. Your top Transpose was creating correctly 18 fields, while the background Transpose had different configurations creating the 4 that Select tool was fed with.

Cross Tab creates multiple rows - Transpose that you are using creates columns.

Hope it helps,

Oly

Trial_proj_oly.yxmd

transpose duplicate.png

apathetichell

@oly- one transpose/once crosstab. I honestly thought this was some weird scam hoax when I saw it. How did the OP remove the crosstab tool and not notice the transpose tool underneath it?

All comments

apathetichell

Do you see your 18 fields in your select tool after you run and refresh your metadata? The Results pain may require a run to refresh - if you attach a browse tool and it doesn't show your data that would be weird - otherwise it's just what's cached.

alteryxworker

Unfortunately, when I refresh and rerun the workflow I get the same results. The results of the output from the cross tab are not the same on the input for the next step. The cross tab yields 18 fields w/ 1 row. The input on the next step is 4 fields with no data.

Thank you for replying.

KSowers10

Have you tried deleting the select tool and inserting a new one? Occasionally there will be some random metadata errors that occur and this might fix it. Let me know!

Qiu

@alteryxworker
This is a very strange issue. have not met it before.

Did you try to delete and replace the Select too and see what happens?

or you can upload the flow if the data is not sensitive.

alteryxworker

Yes, happy to share the worflow - thank you. I have tried deleting the select and the cross tab functions, but still no progress. Any suggestions are appreciated!

Trial_Projections_Aug22.xlsx

Trial_proj.yxmd

apathetichell

you have two tools -Transpose and Crosstab. one on top of each other. the crosstab tool is not connected to the select tool - the Transpose tool is.

oly

Hi @alteryxworker ,

Cross Tab creates multiple rows - Transpose that you are using creates columns.

Hope it helps,

Oly

Trial_proj_oly.yxmd

transpose duplicate.png

apathetichell

@oly- one transpose/once crosstab. I honestly thought this was some weird scam hoax when I saw it. How did the OP remove the crosstab tool and not notice the transpose tool underneath it?

alteryxworker

OP is new to Aleryx

alteryxworker

This of course did it, I am an idiot. Thank you.

oly

@alteryxworker correct, transpose and crosstab overlap. Happy I could help!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335