Im really new to uipath, i tried my best to explain the issue.
I have source file which contain multiple columns but i only need Column A, B,C.
i using read range from source file > Create datatable > Filter data table where i have problem.
i need to keep three output column A, B, C
Column A is staff name
Column B is comments feedback Q1
Column C is comment feedback Q2
Column C header is two questions which has two lines.
How do you like the staff service?
Give your feedback
Filter datatable column header in Uipath can’t read two sentences as 1 value
“How do you like your food
Give your feedback”
How to resolve ?
In source file column B and C some rows has no values but column A has all value in all row, how to remove the whole row where there is no value in column B and C?
I have tried filter row remove row in column A and B (temp remove column C from option)is empty but it don’t work.
While doing workflow test, i manually remove the row without value in column B and C since i can’t resolve. Discover another issue. It seem like variable can’t read cell in Column B due to the column has and mulitple lines and special characters. This cell is meant to be comments field so expected to be max 200 words and multiple lines. How to make it work?
It will much faster manually use excel but is needed to automate.