Incorrect Column Type Preventing ETL
I'm trying to use Magic ETL to transform a dataset using rank&window and remove duplicates. My ETL keeps failing due to the error "Failed to parse data as integer for column". I attempted to input a "Set Column Type" step connected to input but the ETL is failing at the "Input Data Set" stage and never reaches that point. The input dataset is based off a connection to another application (JIRA) and I don't see any way to cast the column type appropriately on the initial dataset. I don't even need the column in question (not including it in my final Select Columns) but it's still blocking the transform.
Is there a way to actually fix the column type in the initial dataset? Or is there another approach I should be using for this transform?
I reviewed some of the other posts regarding similar issues but was unable to find a solution.