Filtering of excel data

Help
, ,
21

if I have 20 company names I have to enter 20 names in the data filter activity …???

22

Else you can save those names In Array and then by using For Each you can loop it
so no need to use 20 filter datatable activity

23

ok… I will try this…thank you so much for helping all of you

24

i’m so sorry about this… I have 125 companies in my list

25

where is Your list of companies names are stored?

26

In my excel data only… one company came many time in my data… that’s why I have 1500+ rows.

27

If those are in excel sheet
then by using For each row u can iterate it
say in 1st row A Company is present
then for that company i.e. NameOfCompany=Row(“Company Name”).tostring
Read Main sheet
Then
Input :- MainDatatable Output:- NewDt
In columns: “Company Name” = NameOfCompany
Write Range to write this Company Data
then Clear Data Table for next iteration

28

Do you have the list of companies???

29

for this in For each row activity I can use data filter activity… you are saying this this only right…??

30

yes I have list of companies with related also

31

This for each row use for Company names only as template

32

This will help you to understand
Comp Data.xlsx (10.4 KB) Company Names.xaml (12.1 KB) Cop Names.xlsx (7.7 KB)

33

thank you so much… I will refer those

34

hi,
I don’t want to store 125 excel sheets but each excel sheet will mail to the respective mail ids… means I want to send to 125 mail ids… which will automatically mail… that I want…
for that i wrote workflow… i’m attaching now… you can refer.Main.xaml (11.0 KB)
any modifications requires in my workflow… you can change

35

Sorry for late reply…

so as i told earlier

after write range you can use send mail activity and then clear that excel for next iteration
Example: Company Names.xaml (15.6 KB) Cop Names.xlsx (7.8 KB)

36

No problem… thank you I will try