Extract Parent Path

[Gokul001 (Gokul Balaji)]

Hi @Sean_Ryan1

1. Use Read Range activity → Store it as DtRead

Use Assign activity

DtClone = DtRead.Clone

DtClone  -> Variable Type | System.data.DataTable

2. use For each row in data Table activity

Inside the For each row in data table activity

3. Use Assign activity

OutputString = Path.GetDirectoryName(Currentrow("Column Name").Tostring)

4. Use Add data Row activity and pass the Value

{OutputString}

Note : If you need to add more column add it.

Outside the For each row in data table activity

5. Use Write Range activity

Regards
Gokul