hello, I am having a weird thing happen with the Read from excel node where it keeps tacking on more null values every time I run it and I dont know why. I keep trying to delete them in excel but there is nothing there and I cant figure it out. any ideas?
Thanks
I believe this is a limit of excel.
Cells A6:A29 and quite a few cells in column B actually contain a null value - there is no data stored there but the are within the overall range of the data. The same thing will happen on a larger scale if you put some data in cell D40. You need to delete the rows if you don’t want them to read as null.
Alternatively you could use a list.clean to return empty lists when there is nothing but null data.