Excel update coulman and removal

Help
, , ,
#1

1: read an excel file with 10 sample rows

2: The excel file should contain Name , Email , Age, Address

3: If the user age is >40 You need to print or add a data column(Age Band/Status) in the Datatable the guy(Nmae of that person) old

4: Write that excel in other file and delete the age column

#2

Welcome @phalguna_M to the community,

If you have any sample excel file you can share…

If not i will make the sample file and attend your query soon…

Cheers.
Vashsiht.

#3

Hi @phalguna_M

I have created workflow based on your requirement please find below attached file run and check I hope you will get the solution.

FilterData.zip (25.3 KB)

Regards,
Kommi Jeevan.

#4

i shared sample excel file
u can share to process steps&screen share

exc1.xlsx (9.28 KB)

#5

check attached workflow I was modified and used your excel file.

image
image455×509 7.27 KB

FilterData.zip (32.9 KB)

#6

my requirement is without using filter data table activity.add data column in datatable see posted in 3 rd line added age band /status in excel file it should contains data
2. using switch activity case1: age >40 it should print in the age band /status other wise default case it should print all in age band/status column
3. remove age data column in the excel file final step write that excel file into another

#7

Hi @phalguna_M,

1.I am doing the changes according to your requirement…

It may take some time…

Cheers.
Vashsiht.

#8

Hi @phalguna_M ,

Please check the attached zip file…
This is the input file…

sheet1
sheet11356×514 26.1 KB

And this is the output file…

sheet2
sheet21362×714 56.5 KB

I hope this is what you expected…

This is the Zip file…
AgeStatus.zip (26.4 KB)

Any doubts let me know…
If you are satisfied then mark it as solution and close the thread…

Cheers.
Vashisht.

1 Like
#9

output is fine but process is different dont go any filter data table activities u just simply show the switch condition instead of filter data table activity
u tried one excel sheet to another excel sheet but i want one excel file to another excel file

#10

1.You can use the collection to store the rows instead of filter data table…
2.You just keep the different excel path and sheet name instead of what i gave that will work fine…

Cheers.
Vashisht.

#11

k u try the condition using switch activity cases

#12

agevstatus file cannot open

#13

The zip file is not opening?

#14

U can try switch activity implementation is possible?

#15

Switch is not technically possible in this case…

#16

K then possible to if condition