StudioX>App Integraiton>Excel>Range

Dear All,

I’m trying to remove duplicate values in a excel file that a defined sheet and defined column.

I’m trying to use acitivty Remove Duplicates under StudioX>App Integraiton>Excel>Range

Even I defined the range I’m getting below error


So if anyone guide me for what is missing, I would be very appricated.


Pls make sure there are values in B column especially in the Sheet1


press the Column button from the activity and from the + menu select the column from which you want to remove the duplicate rows