Forum Discussion
Madhumitha_Mano
2 years agoFrequent Visitor
Un Pivot coulmns issue
Need Urgert Help!!! I have the below the dataset. I unpivoted the columns. but now i see some blanks being reflected even when there are no blanks. I tried query editor but coldn't find the blanks t...
- Anonymous2 years ago
Hi Madhumitha_Mano ,
In the query editor, the default limit for the data preview area is 1000 rows, so that may cause your value for blank to be outside of the 1000 rows.
If you want to view the column data information in detail. You can enable view->column quality.
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Madhumitha_Mano
2 years agoFrequent Visitor
PFA the file. Hope u can access this
https://drive.google.com/file/d/1mLMRmTUP4ZcXh9P_gfvwFfyNphnvxosJ/view?usp=drive_link
Ritaf1983
Super User
2 years agoThere is no access to the file...
You need to modify it for "everyone with the link"