MS Excel – How to create drop-down list in Excel?
Manual input of data in MS Excel forms and text cells can lead to many errors and occurrence of dirty records in your data. If the user makes e.g. a…
Apache Kafka: How to delete data from Kafka topic?
When working with Apache Kafka, there may be a situation when we need to delete data from topick, because e.g. during testing junk data was sent, and we have not…
How to install Microsoft Teams on Windows 7 or Windows 10?
Recently, Microsoft Teams has been gaining more and more popularity among users. All in all, it is not surprising, because currently on the market it is difficult to find a…
Talend Data Integration – Free online course
Are you wondering how to start your adventure in the IT? Are you interested in data warehouses and data integration, but you do not know where to start? Talend Data…
How to install Microsoft Teams on Ubuntu 18.04 (Linux)?
Recently, Microsoft Teams has been gaining more and more popularity among users. All in all, it is not surprising, because currently on the market it is difficult to find a…
How to use Lombok @Builder in abstract java class?
The answer is - you cannot, but you can use @SuperBuilder annotation instead of @Builder. @SuperBuilder was introduced as experimental feature in lombok v1.18.2.@SuperBuilder's toBuilder feature and limited support for…
How to use Pivot SQL function in Microsoft SQL Server
Sometimes you got business requirements to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…
Apache Spark: Convert DataFrame to DataSet – Scala
Many times you might want to have strong typing on your data in Spark. The best to get it is to DataSet insted of DataFrame. In this post I give…
Apache Spark: ReduceByKey vs GroupByKey – differences and comparison
In this post I will try to introduce you to the main differences between ReduceByKey and GroupByKey methods and why you should avoid the latter. But why? The answer is…
Teradata: How to convert rows to columns? Pivot function at Teradata.
Sometimes you got business requirments to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…