I am trying read excel(stored as dt3) as a part of my automation process which has lot of steps. The Excel sheet is empty which is working as expected but when I try to get the dt3.rows.count in the message box, it is displaying blank message output. Actually I need to check this condition in “If” block, but it isn’t working
What can be the issue here? Datatable rows count is blank and Excel sheet is empty. Shouldn’t it be “0” or “1” based on headers property. but why is it blank?
dt3.rows.count will come as an integer value.
If you want to use the if condition.
i think, datatable is not generating
@hemanth_chinna @rajsekhar - Thanks for your response. Am still working on that issue but then I also have another issue and can u please advise me on this? I know to add a new column with default value but how do I handle the below scenario
I have an excel sheet as shown below
But I am looking to modify it as shown below
As you can see, I am trying to add a new column(“View”) to the datatable and each row of column view has a set of values which will repeat every day when I run the script.
Please note that I will be running this script daily to append data. So currently the screenshots has 3 rows for today, but tomorrow it will be 6 rows
How can I do this? I can add a new column wit…
@hemanth_chinna @rajsekhar - Can guys please advise me on this?
Is it possible to create a datatable from a file which is separated by space as shown below
Please note there are 3 rows but all data is put into one column. Instead I want to have 3 rows and 11 columns in a datatable separated by Space delimiter
I can do this using “Text import wizard” in excel but how do I do it using Uipath? Should I still automate the excel steps (text import wizard steps) to convert it into this format?
I want to have a datatable out of this space …
you can use generate data table , there define deliminater in the properties
But it only accepts a string as an input. You are asking me to read all the rows one by one and feed it as input Generate datatable activity? If yes, a) Will it not be a cumbersome approach b) How do I provide the row value in the “Input” field under properties of Generate datatable activity.
ok, text file directly we can pass to generate data table if you have input as a datatable then convert to text using output data table
Thank you Rajsekhar, can you please help me with the below issue as well?
To avoid repeat.
First create a new excel/csv file.
Then you ll need to use new datatable (with View column) to append the data to excel/csv and clear the same datatable after each append activity.
To avoid headers in consecutive runs:
check if the new file exists, if yes use append activity. if no, create file with headers.
I thought I fixed it but the format seems to be an issue. Can you please let me know how to merge datatable? I know the syntax and surce/destination tables but when I merge it the view column is in 2nd position but it starts from 4TH row
build data table dt for only headers
read range generates datatable dt1
add data column view to dt1
assign view values till last row
write range headers dt
then append the datatable dt1
Thanks for the response. Will try your approach and update you.
However Can you please shed some light or guide me on how to approach this?
I would like to verify whether client records grouped based on an unique identifier tallies with bank record.
For example, in the below screenshot, records highlighted green indicate “Bank” records and can be identified using “BK” term in the string. Whereas non highlighted records are client(customer) records.
In the example below, I would like to verify whether records grouped by KID tallies with their respective bank record. For example : Records grouped by A1 would result …
better to create a macro for these type of activities
Can you please help me with this?
I am not able to read a csv file using “Read CSV” operator. It throws an error message as “Invalid format”
However I was able to open other CSV files earlier. The only difference between the CSV file which threw error and the other one is the date format.
File read successful - had date format in DD.MM.YYYY
File read failure - had date format in DD/MM/YYYY.
How can I read CSV with the date format as is. Even if I have to make manipulation to the data, I have to read to make …
please try to connect the CSV file as database connection
@rajsekhar - Thanks rajsekhar. I changed the delimiter to “;” and it started working. Quite weird but it was working. might be a bug. Can you please share your thoughts on the issue below?
Is there are way to change the date format of a column from (DD-MM-YYYY) to dd.mm.yyyy at one go rather than looping through each row and updating it.
I am looking for something which is similar to Python pandas. I would like modify the data format of a column at once. If you could provide a sample, it would be helpful
@rajsekhar - Can you also please help me with this?
I am trying to Find a record in a citrix application. However sometimes due to application issue(old application), it doesn’t return the result even if the element is present. But one good thing is if a record is found, it returns the result immediately and “Stop” button is disabled and the loading bar is also empty. On the other hand when the record is not found, the “Stop” button is enabled and loading bar shows progress in green color. Is there any way, I can use any activity…