Thank you for such an excellent explanation, can you please clear doubt about how we can compare two data table columns and update the value of a particular column as per their matching using Linq or any efficient way. Thank you in advance for your advice and keep making these videos.
It was very helpful video for linq query using invoke code, Can you make a another same video for linq query with two table using invoke code activity?
Hi, Suppose you have to change or replace certain values from the entire column, you'll have to loop through it. Eg: dt1.AsEnumerable().ToList().ForEach(Sub(row) ....) followed by some condition.
how to find if there are duplicate values in specific column consider values test in column 1 and take sum of those duplicate values which values are present in other column it can be 10or 15 or any digit. what link query should be used ?
Can u share an example of how to extract a subset of data table base on a criteria on certain column? For example a column of dates, I only need the rows that have the date within the next three months. Thank u
Hi anmul. I have one question so I have one excel sheet which contains order numbers which is numeric. So some time in the orders column apart from numeric if any type of data like alphabet null some thing like that how can we filter. I hope I will get the solution. Thank you
Hi mam, I exactly did like the way u did,but for me getting error as Option strict on disallows implicit conversion from boolean to string, I have tried with different queries for replacing the value,still getting same error for all queries.Could u please help me with that.
Hi Anmol, thank you for showing this trick. Can you tell me how can I use this to update multiple columns? Beacause this is giving me error io_dt.Select(in_QueryString).ToList().ForEach(Sub(row) row("A")="", row("B")="" ) "No compiled code to run error BC30451: 'row' is not declared. It may be inaccessible due to its protection level. At line 1 error BC30057: Too many arguments to 'Public Overloads Sub ForEach(action As Action(Of DataRow))'. At line 1"
Awesome! I took a few hours looking all over youtube for this exact information and it's nowhere! Thanks a loot
welcome! glad that it helped you.
Great ... Didnt know if we can update multiple rows values
@Deavshish, but now you know :)
Cheers,
Anmol
Thank you for such an excellent explanation, can you please clear doubt about how we can compare two data table columns and update the value of a particular column as per their matching using Linq or any efficient way. Thank you in advance for your advice and keep making these videos.
@shubham : Hi, if the value of two column matches, update the value of both the columns?
nicee video!wht subrow is used?
It was very helpful video for linq query using invoke code,
Can you make a another same video for linq query with two table using invoke code activity?
Great video! How would you go about changing all the values in a single column instead of just the ones equal to 10?
Hi, Suppose you have to change or replace certain values from the entire column, you'll have to loop through it.
Eg: dt1.AsEnumerable().ToList().ForEach(Sub(row) ....) followed by some condition.
how to find if there are duplicate values in specific column consider values test in column 1 and take sum of those duplicate values which values are present in other column it can be 10or 15 or any digit. what link query should be used ?
Can u share an example of how to extract a subset of data table base on a criteria on certain column? For example a column of dates, I only need the rows that have the date within the next three months. Thank u
Hi anmul. I have one question so I have one excel sheet which contains order numbers which is numeric. So some time in the orders column apart from numeric if any type of data like alphabet null some thing like that how can we filter. I hope I will get the solution. Thank you
Hi mam,
I exactly did like the way u did,but for me getting error as Option strict on disallows implicit conversion from boolean to string, I have tried with different queries for replacing the value,still getting same error for all queries.Could u please help me with that.
Hi Anil, the error indicates that your query is returning a boolean value and you're trying to store it in string.
Then we need to assign for a boolean variable type for that query?
@Anil Josh depends on what do you wanna achieve.
good video, but if I want to modify a table by comparing with the value of a column from another table, is that possible?
Yes it is. you want me to cover it?
Hi Anmol, thank you for showing this trick.
Can you tell me how can I use this to update multiple columns?
Beacause this is giving me error
io_dt.Select(in_QueryString).ToList().ForEach(Sub(row) row("A")="", row("B")="" )
"No compiled code to run
error BC30451: 'row' is not declared. It may be inaccessible due to its protection level. At line 1
error BC30057: Too many arguments to 'Public Overloads Sub ForEach(action As Action(Of DataRow))'. At line 1"
Can you try writing two separate queries for different columns, to see if it works?
Exception has been thrown by the target of an invocation error is popping up
in which activity?