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?
@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
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.
Thank you Rajsekhar, can you please help me with the below issue as well?
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
@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?