How to save data ( string) into multiple columns instead in multiple rows

[Rajesh10]

Hello Friends,

please suggest me how to save data into different columns. I have attached two figures to save data. In this vi, the data was saved in different rows (first one) but I want to save it in different columns (second one).

Developed vi is attached below for reference

I am a beginner in LabVIEW, so don't mind for any childish question.

Thank you

 

[GerdW]

Hi Rajesh,

did you read the help for that WriteDelimitedTextfile function? Especially for those boolean inputs of that function?

Did you understand their meaning?

[Bob_Schor]

A Spreadsheet file is a text file, where rows are defined by lines of text (i.e. a <New Line> is inserted into the text string where the line ends) and columns are defined by delimiters (the LabVIEW default being a <tab>, another common delimiter being a comma, which matches the ".csv" extension, for "comma-separated values".

So to have your Rows become Columns, the easiest way is to have all the data in an array (which has rows and columns) and interchange the Rows and Columns.  This operation is called a "transpose", and there is an Array function, "Transpose 1D Array", that will do it.  Give it a try.

Bob Schor

[GerdW]

Hi Rajesh,

---

@Rajesh10 wrote:

---

The expected format is not possible by writing single columns - because of the reason explained by Bob.

Two options:

• collect all data in a 2D array in a way you like and save that 2D array after the loop.
• save the data of each iteration as a single row, with "cycle" text in column A and numeric data starting from column B…

Anyway: whis is basic array handling you should have learned by taking the Training resources offered for free. And it is basic knowledge about CSV file formatting…