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]

Are you able to upload a copy of the file, or a sample from it?

I haven't seen this issue previously, but I'd be interested in taking a look!

[jaygerbs]

Probably wouldn't be a good idea for me.  Input File is .XLS

[jaygerbs]

@echuong1 

I was working on cutting out some of the data, ran the report, & got an error that says "This cell has truncated characters".  Sorry, I can't share the file.....

[Ben_H]

Hi @jaygerbs,

Are you able to provide a sample with dummy headers/data?

Regards,

Ben

[jaygerbs]

@Ben_H @echuong1 

Every time I cleanup the file to be able to send, it works itself out.....  Ugh

[jaygerbs]

@Ben_H @echuong1 

Finally, got a file.  Thanks for looking @ this.

[echuong1]

I'm not sure I understand what the issue with your file is. 

The only field that contains nulls (both after importing into Designer and outputting to another excel file) is Finding Number. This is consistent with the original excel file, where there is only 1 row with a value.

Can you expand upon what the file "should" look like?

[jaygerbs]

@echuong1 Scroll down further, there are some nulls in Action Item Short Desc.

[Ben_H]

Hi @jaygerbs,

Thanks for that. I'm getting the same error you're reporting.

You can see some nulls introduced in the Action Item Column.

I think it might stem from the fact that it's an excel 1997-2003 format but I couldn't tell you why.

Bizarrely I got it to read the whole thing in by reading it as 2 seperate ranges and then unioning.

Not tremendously helpful but I think others might be able to help you more.

Regards,

Ben