Denormalize – Unpivot logic with Talend

Denormalize – Unpivot logic with Talend

for many analyses and applications, particularly data visualisation tools like D3, ggplot2, Tableau, it’s more convenient to have your data “unpivoted” or “denormalized”, Talend is a poweful tool that allows you to do that and create an automated process to do it :

in this tutorial we will do the following “Un-pivol” logic scenario which converts rows of customer to columns :

UnpivotLogic2

 

The job that can do that quickly, in this tutorial we are converting rows to 2 columns, so we do the unpivot logic in three steps.

Leave a Reply