Untyped Data in Dataflow

HI there,

I have seen the same issue. I had unytped columns, complex column and in the end unnamed columns.

I am reading csv files from a Sharepoint folder in a dataflow and combine these. It worked in the past and suddenly I got the error.

I got rid of untyped columns and complex columns by specifically assigning datatypes, even though that didn't seem to be necessary before.

The unnnamed column was created because the most current csv file (Exports from multi-site ERP systems) suddenly had an additional column. This column had data in the csv file, yet somehow importing it in a dataflow it brought up no data or column name (probably because there was a mismatch between the older and the new files?)

I didn't pick up on that until I cross checked the csv file.

Creating a new dataflow reading in only the new file with the new column, I didn't have to assign datatypes again and got a named column with data....

Root cause in my case was the change in the input files.