community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Huge amount of data lost after Crosstab function

I am trying to fetch data from a url (.json) file. I perform some functions like regex and cleaning the data. But when using the crosstab function, the number of rows go from around 730000 to a 1000 records. Can someone help me with what is going wrong. I do not wish to lose any data rows. 

Alteryx
Alteryx

@swati0710 in the group function in the top of the crosstab tool will select the level of detail you want in the rows. I assume the field you have selected here has 1000 unique values. For you to have the same level of detail you will need to select the fields for the level of granularity you want. 

 

You wouldn't have lost data, you would have just summed/concatenated the data into another amount

 

Best,

 

Jordan

Labels