Lesson 9-2 "Column Name" invalid

[siaochuenchong (Chong Siao Chuen)]

Hey Guys,

Currently I have a Filter Data Table Error, and I can’t find it why .

Can you guys spot the error?

Sorry for the time waste!!

Pic%201|690x238

[lakshman (Ganta lakshman)]

@siaochuenchong

Have you checked Add Headers option in Read Range activity or not ?

If not then check that option and then try once.

[lakshman (Ganta lakshman)]

@siaochuenchong

There is some space after ID in Filter DataTable activity and delete that space and try it.

[siaochuenchong (Chong Siao Chuen)]

Hi Lakshman,

I have tried both ways, but it seems the same problem occurs.

[Manish540 (Manish Shettigar)]

Whether you have checked, by giving the output columns also???..

[lakshman (Ganta lakshman)]

@siaochuenchong

What error are you getting here ?

Try with this select query.

       consolidatedDT = consolidatedDT.Select("ID > '50'").CopyToDataTable 

And then use Write Range activity and pass this consolidatedDT to write into Excel file.