Add column with data to excel

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Hi,

I have this excel as shown below and I need to add a new column called “PRODUCT in ICU” whereby everytime we have the data:

1. “…95% ORGANIC COTTON 5% ELASTHANE” in the column “Product Category” it prints:
   "Women’s apparel / T-shirts, singlets - 5% Conventional Elastane (Spandex) + 95% Organic Cotton" in the column “PRODUCT in ICU”

2. when we have “…100% ORGANIC COTTON” in the column “Product Category” it prints:
   " Women’s apparel / T-shirts, singlets - 100% Organic Cotton"

3. when we have “…92% ORGANIC COTTON 8% ELASTHANE” in the column “Product Category” it prints:
   “Women’s apparel / T-shirts, singlets - 92% Organic Cotton + 8% Conventional Elastane (Spandex)”

Please see below screenshot for better understanding.
…

BEFORE:

…

AFTER:

Hope you can help me!

Thanks!
UIPath_Excel_Scratch (7).xlsx (48.9 KB)

[Shraddha_Gore]

Hi @Yudhisteer_Chintaram1 ,

Check this workflow.

54_Add_Excel_Column.zip (15.6 KB)

[Yudhisteer_Chintaram1 (Yudhisteer Chintaram)]

Thanks a lot @Shraddha_Gore !!!