How to concatenate three columns of a row in efficient way?

Learn Academy Feedback
1

hey guys, a data table DT and it has four columns Column1, Column2, Column3, Column4 i want to concatenate first three column and place the value at starting of data table then to excel. any help how to do it?

2

@kishore.shetty

use For Each Row activity to iterate dataTable.

        ForEach row in dataTablename
            Int index = dataTablename.rows.indexof(row)+2
           - use write cell activity and pass 
               below
             Sheet name: sheet name
             Range: "D"+index.Tostring
             Value: row("Column1").Tostring+" 
             "+row("Column2").Tostring+" 
             "+row("Column3").Tostring
1 Like
3

@lakshman

thank you for reply, even i taught to do same but the challenge was to use without for each loop as it consumes most time. Any other method, Do you?

cheers :beers:

2 Likes
4

Hi Buddy

Hope Its resolved here is your xaml buddy
concatenate_modified.zip (13.5 KB) @kishore.shetty

Hope this would help you

Cheers

2 Likes
5

Using assign activity and temp variable create a datatable activity and upload it to excel spread sheet.
For example x=x+y .

1 Like
6

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