My proccess is
- reading the data from a txt file, read CSV
- converting it to a data table,
- Adding a new column to that datatable in the form of (Y/N), Add data column
- Using for each row i then assign Lists for each column
- Then Add to collection for each of the list created
- Then use For Each (Item in col1List)
- Then an if statement with condition col2List(0) = “2”
And here is my question.
when the statement is true i am wanting to write “Yes” in the column i have created and when false “No” given that specific record. It is not working with the current method is have and was hopping to get a solution to this problem as i can not find any resources on this.
Here is my for Each Body so far: