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

image

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

Hi

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

@Unexpected_Irony

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