Run Update Query on data table


#1

I am having a excel, say in following format

Where “Emp ID” is always Unique.
Every time I am getting “Emp ID” as input so on the basis of this I want to update status = “Y”.

Lets if Input is Emp ID = 3, then output excel be like (Don’t want to create new excel on the same excel i want this output)

Thanks in advance :slight_smile: