How to convert datatable values to string and perform Linq query on that?

Help Something Else
1

Hi All,

I have to read data from excel and put in datatable … and perform concatenation of all rows using linq query … First two rows are integers and getting added instead of concatenation. How can I convert it into string ?

  1. First step → Reading data from excel and storing in data table
    (dt_PM0_TableData)

image
image1579×499 33.1 KB

  1. Second step → Using linq query to concat all the values in a row and put in final row

image
image816×742 28.7 KB

  1. Third step → Write concated data in excel

→ Expected o/p for concatenation

999100SAKOCred.of the entrepr.Creditors of the enterprise, 3rd party securities

→ Actual o/p for concatenation

1099SAKOCred.of the entrepr.Creditors of the enterprise, 3rd party securities

→ Attached input file and xaml file

Linq.xaml (10.1 KB)

Can someone please help me in resolving this ?

I have to perform only using linq query bcoz I have huge data

@Palaniyappan @ppr @J0ska @sharathraju489

2

Hi @Mandava_Naresh I have updated your xaml file.Please find it below.
LinqQuery.xaml (10.6 KB)

If it works for you please mark it as solution…

Thanks and Regards.
Sreejith.

3

Hello @Mandava_Naresh

You can refer to the below post for a reference.

4

@sreejith.ss Thank you very much

5

@Mandava_Naresh .
Glad that it worked for you…
Thanks and Regards
Sreejith…

1 Like
6

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