I have a input file I read through using for each. Then for each row in the file I have to run a select. The data table created in the select only stores result of the last row. Please let me know how to avoid the data table in the select activity from being over written.

Are you creating/initializing the data table before you enter the For Each (your scope matters)? Then in the For Each each you would append your records. At end of For Each within the same scope of creating/initializing the data table you should then have all records.

I need little help with a database select using for each function please

Help Activities

GenXDo (Gene Doherty) April 5, 2021, 7:40pm 5

That’s great Mks, glad you got it working. If you could, in the response that included the solution you should have a green checkmark in the bottom list set of options that will mark it as Solved. Here is more details in How to ask a good question?
Thanks, GenXDo

Topic		Replies	Views
Level 1 Foundation Training - Lesson 3 Data Manipulation Academy Feedback	5	929	September 5, 2019
How to use For Each wisely here ? (Case question) Studio studio , question , properties_panel	5	294	July 11, 2023
For each - decision based on content Help	6	912	November 14, 2018
How to store values in for each loop? Help activities , question , data_manipulation	1	1417	January 19, 2020
For Each Row in Data Table fail. Why? Activities excel , activities , question	10	321	September 6, 2023

Most Active Users - Yesterday
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu
More details...

I need little help with a database select using for each function please

Related Topics