Below is a scenario about singularization of a data before Bussion. Data in Data File are the ones to be send to Bussion. Out of these data the areas to be changed are changed from Look Up table. In this case in Data File>Customer area there are Customer info. So in Bussion side to be able to create proper reporting this area has to be singularized according to the Look Up areas values.
In Data File>Customer Info (below Table-1) can be differently written. This happens when source data is not straight or when trying to unify datas from different sources. For a proper Data transfer all the differently written values must be set as IDEA TEKNOLOJI value. Below Fuzzy an algorithm make these changes for both the column and all the lines. Corrected Data Sets then during the next steps of the process, edited and transferred to Bussion.
|Look Up||Data File||LAST VALUE|
|IDEA TEKNOLOJI||IDEA TEKNOLOJI||IDEA TEKNOLOJI|
|IDEA TEKNOLOJI||IDEA TKNOLOJI||IDEA TEKNOLOJI|
|IDEA TEKNOLOJI||IDEA TEK||IDEA TEKNOLOJI|
|IDEA TEKNOLOJI||IDEA TEKNO.||IDEA TEKNOLOJI|
|IDEA TEKNOLOJI||IDEA TEK.||IDEA TEKNOLOJI|
Table 1 - Ex:Customer Info
Picture 1 - Process designed for ETL
Picture 2 - Visualization fo Transferred Data
If you need complex data transformation, it is possible to design processes, transferring changed or calculated data to Bussion.
For more information please contact us.