03-29-2017 12:59 PM
Okay, I said I had an error.. and I just want to come back and say that I have resolved the issue:
1. Issue is I'm doing my data cleansing in the "Transform Sample Data", the raw data has a column which is supposedly a number.
2. The sample data grabbed (this one single file among the many) has all values in that field as a number
3. Now here's the BUT..... But, the are other raw data that had a dash(-) in that column where it's supposed a number.
4. That is what caused that error to trigger.
Solution, add a filter (filter out "-") via Advanced Editor since via UI would not let me since it recognizes that the sample data had all number in that column, even though I inserted the step right before Data Type assignment.
That's it in my case.
03-29-2017 01:04 PM
Ooops, I just realized that I posted in a very specific discussion but nevertheless I hope my entry can help someone else. Thanks for reading anyway.