Input to output file is replacing some data with "null" and it shouldn't be

[jaygerbs]

Hey all!

I have a column in my Input File (Microsoft Excel) labeled "Action Item Short Desc./Reference", but in my output file it changes it to "Action Item Short Desc#/Reference", not a big deal, but when I run the workflow it leaves some rows in this column as "null" in some instances..... and it shouldn't be!!!

Anyone else experience this or have a workaround.

I have renamed the column, but that doesn't seem to help.  It comes from a report, so changing the input column name won't be easy...

Thanks!  JG

[echuong1]

How strange, I don't have any nulls in that column upon import. The only data quality issue with that field are that there are leading/trailing spaces.

What version of Designer are you on? 

[jaygerbs]

@echuong1  2019.4.  We don't get the updated too often.....  

@Ben_H  appears to be b/c of truncated characters.  What version are you running?

[jaygerbs]

@Ben_H That just cleaned up the nulls.....  Thanks thou