PengjinfengHow to Check & Get Specific Excel Cell Values in JavaBelow is part of Excel file emp.xlsx:2 min read·Feb 2, 2021----
PengjinfengHow to Filter an Excel File in JavaBelow is part of Excel file emp.xlsx:2 min read·Feb 2, 2021----
PengjinfengHow to Perform Row-to-Column Transposition in MongoDBRow-to-column transposition is often needed in handling MongoDB data in real-world businesses. We have a collection scores that records…2 min read·Jan 29, 2021----
PengjinfengHow to Group & Summarize MongoDB SubdocumentsSometimes we have the requirement of dividing MongoDB documents into multiple segments by specified intervals and performing an…2 min read·Jan 22, 2021----
PengjinfengHow to Make a Crosstab in MongoDBCrosstab is a commonly used grouping & aggregation table. It shows the aggregates on a specific field and groups them; groups rows by a…3 min read·Jan 22, 2021----
PengjinfengHow to Get Record with the Latest Date from Each Group in MongoDBIt’s not uncommon that, during a statistical analysis project, we need to check the record with the latest date in each group after…3 min read·Jan 22, 2021----
PengjinfengHow to Combine Subdocuments of Different Attributes in MongoDBMongoDB can record multiple attributes and provide moredetails of a subdocument through nested structure. Below is blog collection. There…2 min read·Jan 15, 2021----
PengjinfengHow to Combine Fields of Same Attribute in MongoDBAs a document-based database, MongoDB allows storing data in a convenient and flexible way. Data of same or similar attribute can be…2 min read·Jan 14, 2021----
PengjinfengPerform Distinct Count over MongoDB Nested SubdocumentsNested structures are common in MongoDB data. The database uses nested subdocuments to represent the one-to-many relationship. But, when…3 min read·Jan 14, 2021----
PengjinfengQuery Nested Subdocuments in MongoDBAs a NoSQL database, MongoDB can increase horizontal scalability and performances and achieve a one-to-many relationship through nested…2 min read·Jan 14, 2021----