DT not appended in Excel that has VLOOKUP

I have a DT that I append in an excel worksheet, it appends earlier when I didn’t add a Column that has a VLOOKUP, after adding the column that has a VLOOKUP, my DT doesn’t seems to be appended.

Hi @wdescalsota ,

I have tried to reproduce the problem that you described but even after adding the VLOOKUP column it still appends the datatable. I am using 2021.4 Studio version and did a simple sequence as can be seen in the following picture:


image
Maybe you could share your code and a sample excel file, so we have more info.

Constantin