i have one Excel which Contains Data Suppose like
so I want only Joya from it
i guess this will help you out
Havn’t get idea i just want a word/character data from Excel Column like Above
If you need to get the whole row which contains the keyword Joya, you can use Select statement or Filter table activity. Please see the below links for your reference.
Select statement example below. This will give you the rows which contains only Joya.
Assign OutputDT = inputDT.Select("[Name] = 'Joya'")