Columns in excel are empty

empty

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
image
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

filter
this is what iam getting …any idea?on this

1 Like

@priyankavivek

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

string

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

scroll%20activity

any idea on this i used web recording but selector issues