check availability

[#1]

hi, i want to check 3 excel sheets to if they are having my items. if they have i want to create a column with 'yes'. how can i do that?

[Anonymous]

Post some sample to better understand your requirement,

Regards

Nitin

[#3]

Hi Chathurnaga,

I am not realize clearly, please post sample excel or script,

Try to add, when you are load data from excel file ADD where clause, then add concat or “&’ with column name in resident table.

[jagan]

Hi,

Can you come up with some sample data and explain.

Regards,

Jagan.

[#5]

hi, sorry guys. found the solution. thanks