Split Data in Excel file into multiple Excel File

Hi,
I need to split the data into multiple excel files based on the input data
Locator Data.xlsx (7.7 KB)
In every excel file I need data in this format using filter data activity
customerName, Germany
CustomerName, Mexico
CustomerName, NetherLands
CustomerName, New zealand
CustomerName, Nigeria

(as below mentioned format)

CustomerName Germany
ANDHRA PRADESH GRAMEENA VIKAS BANK 4
PUNJAB NATIONAL BANK 6
CHAITANYA GODAVARI GRAMEENA BANK 8
PUNJAB & SIND BANK 3
ARUNACHAL PRADESH RURAL BANK 3
MAHARASHTRA GRAMIN BANK 7
CENTRAL BANK OF INDIA 8
UCO BANK 9
ANDRA PRAGHATHI GRAMEENA BANK 5
UNION BANK OF INDIA 0
CANARA BANK 6
INDIAN BANK 4
BANK OF BARODA 0
STATE BANK OF INDIA 3
BANK OF MAHARASHTRA 2
MEGHALAYA RURAL BANK 5
MADHYANCHAL GRAMIN BANK 6
BANK OF INDIA 2
NAGALAND RURAL BANK 7
MIZORAM RURAL BANK 8
INDIAN OVERSEAS BANK 5
MANIPUR RURAL BANK 1
LAND ROVER 9
SCODA 6
RENAULT 8

@mohan_sai365

Use filter datatable activity…and open filter wizard…in that go to columns tab and select keep and give the customer name and the required city name…repeat the same for each city…

Thwn thw output will be as you need

Cheers

Hey buddy. @mohan_sai365
Is this the same query
Then you can refer this I have used the filter data table activity there.

Regards.

2 Likes

Hey @mohan_sai365

Hope this is helpful.
Here used multiple filter activity for seperating each city.
Excel Forum.zip (20.4 KB)

Cheers.

2 Likes

Hi Divakar,

I need to get the data in the same format for all the data like
Customer Name, Mexico
Customer Name, NetherLands in a separate excel file

Hey @mohan_sai365

Is this what you want.

image

Try this.

Task Excel Forum.zip (42.6 KB)

Hope this will help.
Regards,

2 Likes

Hi @mohan_sai365

Try this
Test.zip (42.4 KB)

Hope might helpful for you

5 Likes

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