CrossTab does not support renaming of duplicate fields.

Getting this error and I'm not exactly sure what it means. I am trying to pull my data together so I am using a Basic Data Profile tool and then going straight into a Cross Tab tool. What I was expecting to happen is that each row would be one column worth of data. It appears to be when I am trying to group my Cross Tab.

CrossTab_Dup_Field.yxzp

Transformation

Accepted answers

harend

So I came up with this solution and now the error makes sense. Add a select tool between the basic data profile, and the cross-tab tool. Change the FieldName column to anything else (I actually used that but you'll probably have a better name) and then run your workflow. Everything should come up peachy! I've attached the workflow that I used to get the solution.

CrossTab_Dup_Field.yxzp

All comments

harend

Hello!

The error you are seeing is due to you having multiple Name values that are the same ie FieldName, FieldType etc. I'm not sure what you mean by using a cross tab to get "that each row would be one column worth of data" because you will have too many dimensions in your data. A solution I could see working would be to filter based on the FieldName column and then cross tab those. That would allow you to pivot your data and then union it all back together and that would give you some better analytics on your data. If this isn't what you were shooting for let me know and we can find what solution you are looking for.

kevinbird15

I was under the impression that the Group Data by these Values would allow me to have each row be a field name so I wanted it to be similar to this:

FieldName	FieldName	FieldType	FieldSize	FieldSource	Count Null
Street_Name	Street_Name	V_String	30	TextInput:	36
Count1_Traffic	Count1_Traffic	Int32	4	TextInput:	0
Count1_Type	Count1_Type	V_String	24	TextInput:	0

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703