Pivot Transformation in Magic ETL not Pulling in 4 columns? HELP
Data is coming from Survey monkey; therefore, I have to transform the data from rows to columns.
I have 18 columns that I do this with; using one pivot transformation, since all the data is similar (i.e. #1, 2, & 5) (1st pic).
The issue is 12 columns are able to transform the data, however, four (2nd pic) is coming in null.
I have checked the actual labeling from the source data and it is correct; however, it pulls in null.
I know there is data because I isolated (using a filter) to see the data. It doesn't like something about the label or something. I tried taking away the HTML tags (didn't work). The labels and data are in the 3rd pic.
Any assistance would be greatly appreciated. I am at my wits end. ;-(.