Combine Two Excel sheets together

[A1992444]

I have Two while loops in one LabVIEW block diagram, The two while loops are separated. the first one for pressure and the second one for temperature. I have already made the to write measurement file for each one to get the data in an excel sheet. after running the experiment, I already get two excel sheets. the first one for the pressure and the second one for the temperature. How can I combine these two data excel sheets in one excel sheet to generate all the experiment data ( pressure and temperature) in one excel sheet instead of two excel sheets? 

[altenbach]

Your images are completely useless because we can't even see the two while loops.

Lots of parts we see make very little sense, for example what's up with the "Dynamic-to-1Darray-to-Dynamic" song and dance you do everywhere? I am sure there would be a much cleaner solution without and dynamic data and express VIs.

Please attach your VI.

[A1992444]

This is the VI File. 

[kartiknattar]

Since your loops are not synchronized and you are not using report generation toolkit, you cannot create single file for data storing.

What you can try is first save the data in lvm format in both the loops and when the program stops open both of the files, merge the data and then save it in a common excel file.

 

[A1992444]

I am thinking to make a report generation to get all data in one excel sheet !!!

[kartiknattar]

You can use a third loop to combine all data  (using local variables) and merge them into a single file. Make sure you set appropriate loop timer.