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.
In the transpose tool the Data Fields are not selected ( i am not sure which ones to select to I selected all) and following that Filter tools is looking to filter for the criteria Right([Name2],6)=='UserID' && !IsEmpty([Value])
Right([Name2],6)=='UserID' && !IsEmpty([Value])
but there is UserID suffix in any of the fields.After that it is summarizing on CollectionId which is missing , So i am not sure if I am understanding it wrong or there is any missing information
If it's just the transpose tool giving you trouble, you want to select CollectionID & Name on the top, and then everything EXCEPT those two on the bottom. If your mongo configurations are working, that should do the trick.