How to Configure Write Cell Activity Inside a For Each Row Loop to Write A value In A Cell

[teo_choudu]

Hi,

I had put a loop inside a loop. For the inner loop, I want to write cell to excel last row with the respective row for the outer loop table. How can I do that?

Thank you.

[pattyricarte (Patty Boy)]

Hi @teo_choudu
Can you give the sequence of details of your process?

cheers

[teo_choudu]

Hi @pattyricarte

[pattyricarte (Patty Boy)]

Ok thanks for the info @teo_choudu

I’ll check it

cheers

[teo_choudu]

Thank you @pattyricarte.

I want to write the respective row of ExtractDataTable1.

[pattyricarte (Patty Boy)]

Noted for that @teo_choudu

cheers

Happy learning

[pattyricarte (Patty Boy)]

Hi @teo_choudu
I will give some scenarios.

I will chunks the scenario .
1.You want to loop with in this Datatable ?

2.After that you need to iterate to DT2 DataTable.

• Upon Iterating to DT2 Datatable you need to get the last row of DT3 Datatable.
  

3.Then you want to write the value of ExtractDataTable using the count that we get in DT3.

Are these correct?

cheers

happy learning

[teo_choudu]

Yes. @pattyricarte You are right.

[pattyricarte (Patty Boy)]

Ok I guess your xaml is doing right.If we perfectly aligned

By the way what is the issue of your xaml ? At my first glance i think the flow is doing right just need a little bit of cleaning the codes.!

cheers

happy learning

[teo_choudu]

Thank you very much.

[pattyricarte (Patty Boy)]

No problem @teo_choudu

Happy to help here!

cheers

Happy learning

[teo_choudu]

Hi @pattyricarte,

I had tried to change the text input for write cell activity, but it still not works as what I want.
May I know what should I change.

Thank you.

[pattyricarte (Patty Boy)]

May i know what error did you encounter?

@teo_choudu

cheers

Happy learning

[teo_choudu]

There is no row in position -1.

[pattyricarte (Patty Boy)]

Can you scrreenshot the activities Please. Thanks.

cheers

Happy learning

[Manohar1 (Adicherla Manohar)]

@teo_choudu

For Better practices try to use read range activity outside the for each loop.
and try to debug the process and check at each step what it is printing.

Regards,
A Manohar

[pattyricarte (Patty Boy)]

Can you give also the excel file ! @teo_choudu

cheers

Happy learning

[teo_choudu]

Sorry its confidential

[pattyricarte (Patty Boy)]

Ah ok thats fine. by the way what ativities did you get the error.

I’am looking at your xaml!

cheers

Happy learning

[teo_choudu]

What information from ExtractDataTable1 that I want to save in LastRow of Url excel is not correct exactly