Suggest a linq expression to add ' infront of second column of the DT

Help Activities
, ,
1

Suggest a linq query to add ’ infront of second column of the Data table so that second column data would be in same format.

2

Hi @Gopi_Krishna1

Could you share a sample input and output required?

Thanks,
Srini

3
4

Hi @Gopi_Krishna1,

Use this in Invoke Code activity:

dtFinal.AsEnumerable().ToList().ForEach(Sub(row) row(1) = "'" & row(1).ToString())

image
image900×475 21 KB

Input:
image

Output:

image

Thanks,
Ashok :slight_smile:

5

Hi @Gopi_Krishna1 ,

Try this

(From row In Final_Dt.AsEnumerable()
Let newValue = "'" & row.Field(Of String)("yourcolumn_name")
Let otherValues = row.ItemArray.Skip(1).Select(Function(x) "'" & x.ToString()).ToArray()
Select Final_Dt.Clone().Rows.Add({newValue}.Concat(otherValues).ToArray())
).CopyToDataTable()

Regards,
Vinit Mhatre

1 Like
Forum Engagement Daily Reports
7

My first column is replaced with second column, please fix that :relieved:

8

Can you share me your input data and expected output

9

I have modified my code my myself thanks vinit😊

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.