This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
@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