Remove values from multiple columns based on another column

[SunnyJha]

Hi,
I want to remove any values present in SAP Mapping 1 to SAP Mapping 5 if the Promotion is CR or NR.

i/p:

o/p:

[Anil_G (Anil Gorthi)]

@SunnyJha

follow steps

1. Use excel file
2. For each row in excel and give Excel.Sheet("SheetName")
3. Inside loop use if condition with currentrow("Promotion").StringValue.Equals("CR") Or currentrow("Promotion").StringValue.Equals("PR")
4. on then side use assign with currentRow("SAP Mapping1") = ""… repeat this assign for all columns you need

cheers

[SunnyJha]

Thanks Anil. I think I am having a brain freeze as I forgot this is a simple for each case.