the output of the excel have empty spaces how can i eliminate? those
You mean you want to delete them @priyankavivek
if so you can use filter datatable activity and mention all the column name and put the value as Nothing and enable the Remove radio button in the filter data table activity wizard
Cheers @priyankavivek
in output datatable what shall i use?
1 Like
You can mention a new datatable variable
Of name FinalDt in the variable panel…
Kindly mention the default value as new system.data.datatable
Or simply a ctrl+k in the output datatable field in filter datatable activity wizard buddy
Cheers @priyankavivek
1 Like
this is what iam getting …any idea?on this
1 Like
Could you please show me the screenshot of your Filter DataTable activity and need to check once how you passed.
1 Like
No worries buddy @priyankavivek
This error usually occurs when the column name mentioned in the filter datatable activity wizard is not in the datatable we have…or there must be spelling mismatch…or we would have not mentioned the column name as string between double quotes… Like this “YourColumnname”
Check with these and let know buddy
Cheers @priyankavivek
may i know where you are getting this outt datatable buddy @priyankavivek
from build datatable output
Great
can i have a screenshot of that buildatatable wizard with column names
@priyankavivek
this actually happens because of column spelling mismatch @priyankavivek
so this can be easily resolved
Cheers
1 Like
were you able to find the mismatch in them
@priyankavivek
mismatch items donot print on excel sheet,so i had emptied columns in it,therefore i have used assign in the else to print those datas in it
Fine
1 Like
thank you so much for clarifying the doubt…
No Worries,
Cheers @priyankavivek
Keep going
1 Like
hai buddy i have some doubts in fwd insurance site can you please help me with it?
1 Like
yes of course
may i know what was the issue
@priyankavivek
i have to click the option which has multiple options
any idea on this i used web recording but selector issues