03-19-2021 07:37 AM
Hi,
I faced a problem as mentioned below.
1) i can't get incremental iteration1 (refer to excel sheet column D). In fact, what i want is 1,2,3,4,5,6.
2) incremental iteration2 (refer to excel sheet column E). In fact, what i want is 1,2,3,4.
3) 3 extra data, 6 (refer to excel sheet column A,B and C).
What i can get is the end number (6 in excel sheet column D and 4 in excel sheet column E).
Attached 2 image files. "Test result" and "expect result" .
Attached a project file for your study and correction.
thank you very much.
best regards.
Solved! Go to Solution.
03-19-2021 09:30 AM
I find it interesting how different people find solutions. What thought process was used to come up with this?
03-19-2021 10:22 AM - edited 03-19-2021 10:23 AM
I think this is what you are after. I highly recommend you avoid using the Write Delimited Text File when you repeated write to a file. Instead, open/create the file, write your header, inside your loop you write to the file, and close the file when you are done. You should also avoid pretty much anything in the Express palette because the Dynamic Data Type is a cancer. You can just use Build Array instead.

03-19-2021 06:49 PM
Hi, Crossrulz,
Thank very much for helping me solve my problem.
best regards.