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

studio

#1

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.


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

image

image


SELECT with string to integer/decimal PARSE is not working
#3

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


#4

Got it… thanks


#5

Great. :slightly_smiling_face:

Please mark the solution as solved.


#6

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.


#7

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.


#8

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


#9