How to Split data using Filter data Activity

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)

1 Like

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.

10 Likes

Hi @mohan_sai365

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

Hope this helps

2 Likes

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