How to filter out excel column records where records start with "K"

I have a excel file, where more than five thousand records present in one column . I have to filter out records which start with “K”. Please suggest.

  • Use Read Range activity to read it as Datatable.
  • Use Filter datatable activity.

image

image

1 Like

Is “Filter Database” activity available in studio???

Got it… thanks

Great. :slightly_smiling_face:

Please mark the solution as solved.

Hi Vivek… I tried the same… but not getting the result… Could you please share a small solution on it… Help will appreciable. Thank in advance.

Hi Vivek, I tried this… Not fulfilling my logic. Becasemy process is like this, Suppose If I will filter out Column A value which starts with “K”. Then after filter other related column should be filter too. as per related value.

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.