Hi @Naman_Arora ,
I think we can set it when get from web
or when you get like that, we can remove values in cell which we don’t need keep
can you share your website need get data or your data and expect output
regards,
@vinitha_yachamaneni Thank you so much I can try this. But the variable in Data Table, I want to write as a string in each cell. If there possibility to do that ?
@Nguyen_Van_Luong1 Hi I places a selector on that particular value but it not extracting that, So I placed a selector on the whole box. Then it’s started extracting the values with these extra work words like “New column 0
language tag
Decide for me”.
(From row In inputDataTable.AsEnumerable()
Where Not {"New column 0", "language tag", "Decide for me"}.Contains(row("YourColumnName").ToString)
Select row).CopyToDataTable()
I got it @Naman_Arora
I want to know when you select specific value, what is the error here?
When you select all the data you have, you need to delete some unnecessary values, that’s right
→ I think taking it all and deleting some unnecessary values can be used
can you share your opinion about the data when you get it all and expect the output, we can use for each row of data to delete all the rows which we don’t need
You can see in the input in build data table …it will remove the New column 0,
language tag,Decide for me if it present
try this query
(From row In dt.AsEnumerable()
Where Not {"New column 0", "language tag", "Decide for me"}.Contains(row("Text").ToString)
Select row).CopyToDataTable()
To remove specific rows from a DataTable in UiPath based on a condition, you can use the Select method to filter the rows you want to keep and then create a new DataTable with those rows. Here’s how you can achieve this using an Assign activity
DataTable = DataTable.AsEnumerable() _
.Where(Function(row) Not row(“ColumnNameOrIndex”).ToString.Contains(“New column 0”) AndAlso
Not row(“ColumnNameOrIndex”).ToString.Contains(“language tag”) AndAlso
Not row(“ColumnNameOrIndex”).ToString.Contains(“Decide for me”)) _
.CopyToDataTable()