Category "transformation"

Informatica: Data in column looks like 00003242-2-0-1,00000925-1-0-1,00003214-2-0-1 .In target I need data like 3242, 0925, 3214 in different rows

Data in one column looks like this 00003242-2-0-1, 00000925-1-0-1, 00003214-2-0-1. In target I need to get only data like 3242, 0925, 3214 in different row

Getting duration is seconds between datetime rows in SSIS

I have an event-based csv file that logs an event along with the time of execution. I need to be able to get the duration between the events by taking the DateT

Transform a dataset from wide to long pandas

I have a little problem with the transformation from wide to long on a dataset. I tried with melt but I didn't get a good result. I hope that someone could help

Can we call any external REST API inside DBT(Data Build Tool)?

I am working on some analytical work and we need to transform data from one source to another and we are using DBT for transformation purpose. one of the data a

Can we call any external REST API inside DBT(Data Build Tool)?

I am working on some analytical work and we need to transform data from one source to another and we are using DBT for transformation purpose. one of the data a

Box-Cox Transformation in SPSS

I transformed my stat data with logarithm, square root,... but my dependent variable doesn't achieve normality distribution yet. Then, I know that the Box-Cox

Average transformation matrix for a list of transformations

I have multiple estimates for a transformation matrix, from mapping two point clouds to each other via ICP (Iterative Closest Point). How can I generate the av