Query Regarding Looping

Help Activities
1

Hi Folks,

I have a datatable with values

910217,1,1,1,1
910217,1,1,1,1
910217,4,4,4,4
910217,4,4,4,4

I want to this datatable to look like (suffix 000000, 100000, 20000, 30000)

910217000000,1,1,1,1
910217100000,1,1,1,1
910217200000,4,4,4,4
910217300000,4,4,4,4

Suggest best approach towards this ?

2

Assign the values to array which you want to suffix
2.use for each row datatable activity
Inside use
Assign currentrow(“ColumnName”)=array(idx)

Here idx is the output of for each row datatable activity

Hope this helps

3

Hey @shikharno.7 ,
I have worked on your requirement and attached the file below
New folder.zip (3.4 KB)

Below is the output screenshot
image

Hope it helps you out

4

@Vikas_M , the first value should be 910217000000 instead of 9102170. Could we do that pls ?

5

Hey @shikharno.7 , Sure we can do that
Below is the updated file
Shikharno.zip (3.4 KB)

Below is the output screenshot
image

Hope i helps you

6

@Vikas_M

Thanks a million for the solution and xaml file :slight_smile:

Would this solution be feasible for 1000 rows, as I have to use this logic for 1000 rows ?

7

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