PengjinfengHow to Check & Get Specific Excel Cell Values in JavaBelow is part of Excel file emp.xlsx:Feb 2, 2021Feb 2, 2021
PengjinfengHow to Filter an Excel File in JavaBelow is part of Excel file emp.xlsx:Feb 2, 2021Feb 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…Jan 29, 2021Jan 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…Jan 22, 2021Jan 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…Jan 22, 2021Jan 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…Jan 22, 2021Jan 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…Jan 15, 2021Jan 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…Jan 14, 2021Jan 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…Jan 14, 2021Jan 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…Jan 14, 2021Jan 14, 2021