Hi,
Can someone help me perhaps. I want to make a robot that can read a excel file and based on that content, sending a email to them
Here is what I got so far:
but I keep getting a error:
Cheers,
Hi,
Can someone help me perhaps. I want to make a robot that can read a excel file and based on that content, sending a email to them
Here is what I got so far:
but I keep getting a error:
Cheers,
Hi
Kindly check whether the Addheaders is enabled in read range activity buddy
or use column index for that column and usually the Column index of column will start from 0 for
Cheers @ukjtenhoven
Hi @ukjtenhoven - Please check, is there a column name called “C” in your input? Or check whether you checked “Add Header” in Read Range Activity.
Thanks,
AK
Sorry typo mistake, thats column index,
we can use column index like row(2) instead of row(“C”)
here i mentioned as 2 as the column index for example, it usually starts from 0
Cheers @ukjtenhoven
So I need to replace all the “C” with “2” right?
Cheers @Palaniyappan
yes if the column “C” is third column then replace with like this
row(2).ToString
Cheers @ukjtenhoven
It is working but it’s not removing the duplicate names . So it sends email again and again and again. Do you know how to fix that perhaps?
Cheers @Palaniyappan
Remove duplicate rows should remove them
What is the variable name of read range and remove duplicate rows in your workflow
Cheers @ukjtenhoven
ehmm the output from the read range is: outdt and the input from the remove duplicates rows is: outdt and the output is: Final_dt
Cheers @Palaniyappan
That should actually work, strange
fine lets check the value of the datatable after the remove duplicate rows
–use a output datatable next to remove duplicate rows and pass the input as Final_dt and get the output with a variable of type string named out_text
–use a write line and pass the input as out_text which would print the output of the datatable after removing the duplicates, as a string
Kindly share that screenshot buddy
Cheers @ukjtenhoven
Still not working… everything is the same still.
but it only needs to remove the duplicated rows of the names, right now it gives a output of the whole excel file.
Cheers @Palaniyappan,
The reason why this didnt get filtered with duplicates…is that each row with each column has some distinct values in it…thats why…
Fine
Which column you want to remove with duplicates
Cheers @ukjtenhoven
Only from Colum C Right now I have this:
the problem is that the remove duplicates range is not working.
Cheers @Palaniyappan,
Nevermind I fixed It I added the other Remove Duplicate rows and I selected Column C.
Well that was actually suggested here
Oh that’s my mistake I thought it said Remove Duplicate Range
Cheers @Palaniyappan,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.