How to Split data using Filter data Activity

[mohan_sai365]

Hi, I want to get an output like customer name, Germany column in a new Excel workbook, attached the Input data
Locator Data.xlsx (7.7 KB)

[Chirag_Shetty_Divakar (Chirag Shetty)]

Hey @mohan_sai365

Hope this helps
Excel.zip (18.1 KB)
Cheers.
task excel forum.zip (18.0 KB) *Edit This is using filter data table activity
Cheers.

[Suraj_B_Shetty (Suraj)]

Hi @mohan_sai365

Give a try to this.
dt_input=dt_input.DefaultView.ToTable(false,“CustomerName”,“Germany”)

Hope this helps