I've imported 9 csv files from a folder location, promoted the headers and then filtered the rows to remove the headers of the other 8 files. I've then tried to fill down the first column to complete the values across the 9 source files but nothing happens. Has anyone else experienced this? Is there a way round this or something I'm missing?
Fill Down only affects "null" (empty) cells, but it looks like you have blank values instead. "null" values appear with the word null in italics.
To replace your blanks with nulls, first select your prior step Filtered Rows. Then select the columns and use Transform / Replace Values. Leave the Value to Find empty and type null in the Replace With field.
Great - thank Mike. I had tried to fill with null values but was using capitals - didn't realise it would be case sensitive! That's worked a treat.
