Iteration through datatable

Help
1

Hi ,

I am extracting a datatable in SAP for different transactions in a for loop and using a filter wizard activity to apply some filters too. Each transaction will have a different DT

After first transaction, I am clearing the filtered DT using Clear Datatable activity, and when i prints it -it just gives headers (As expected)

But in the second iteration, filtered DT still shows the first DT filtered values which I do not need.

Please help .

2

Hi @Teenu

May be the filtering part is not working as expected. Have you checked whether it is working as required?

1 Like
3

filter part is working as expected

4

Hi @Teenu did you clearing the both dts i mean filterDT and extracted dt.

5

No only filterDT

6

Extract DT
FilterDT
Iterate and then clear filtered DT
Next iteration-filteredDT not clearing ,it has first iteration rows.

7

okay …fine do like this for filterDT initlize filterDT with new Datatable() when nieration starts.

8

No, its not working

9

can you please share you xaml here

10

hey Thanks Kalyan, its resolved.
I have used SELECT with ExtractDT and cleared DT. It works fine

Thank you so much

11

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