-
Converting text to date in ETL
Hi all, I'm trying to convert a text into a date field in magic ETL, and I'm running into errors and unexpected outputs. Screenshots below. When trying to just convert the (numbers as text) into dates, I'm receiving the error "An invalid date was found". When I conver that column first from text to numbers there's no…
-
Counting characters in ETL?
Hi there, I know there's a way in Python to count characters similar to LEN() in Excel, but I don't know Python at all to be able to use it as a tile in the ETL. Can someone help me figure out how to add a new column of character count to a dataset using Python? Thanks!
-
Rounding a date/time field to the nearest half hour
We have a date/time field that I'd like to accomplish the following with: * Split the date and time into two separate columns (while also maintaining the original column) * Round the time down to the nearest half hour increment (for instance, 8:43 would round to 8:30, 8:18 would round to 8:00, etc.) Issues to be…
-
Removing duplicate from group by strings separated by comma
Using the ETL tool, I've got a column that is ALMOST exactly what I need. I'm trying to identify the sales type mix of a customer's basket with the number of units in the basket, see image for example. What I'd like to do, though, is remove the duplicates from that column. For instance, in the row that has '2' units with…
-
Any successful JSON connections?
Hi there, I'm attempting to use the basic JSON connector, and I run into what I believe is a column limit error. I want to use the connector to filter down to specific properties, but I'm not sure what the syntax is for this field or even JSON in general. Does anybody have any good starting points on how to learn or where…