f



How to read every data in the first column corresponding to the every data in the second column in the TABLE CONTROL?

Hello everyone
 
like this table 
 
0.0001          -4.6
0.0002          -4.3
0.0004          -4.0
0.0006
0.0008
0.001
 
I want to get  pairs (0.0001, -4.6) (0.0001, -4.3)  (0.0001,  -4.0) (0.0002,  -4.6) (0.0002,  -4.3) (0.0002,  -4.0) (0.0004,  -4.6) (0.0004,  -4.3) (0.0004,  -4.0)........
to control the number of loop
 
so how cam get this whole pairs?
 
Thank you for any help!
Jing
 
 
 ??????06-20-2008  09:07 AM?????


different F many measurement.vi:
http://forums.ni.com/attachments/ni/170/333583/1/different F many measurement.vi
0
x9561 (148440)
6/20/2008 2:10:09 PM
comp.lang.labview 35213 articles. 1 followers. vasusachin24 (1) is leader. Post Follow

7 Replies
810 Views

Similar Articles

[PageSpeed] 55

I'm not sure I understand. Your code already shows you autoindexing the outer for-loop so it runs for each row. And the inner loop is set to run a constant 100 times for each row, and you're indexing out each column from the specific row that is currently being executed. So what's the problem?
0
x9561 (148440)
6/20/2008 2:10:09 PM
Hi,It's not pretty but how about this?<img src="http://forums.ni.com/attachments/ni/170/333596/2/col1%20with%20every%20value%20of%20col2.PNG"> First turn your input table into a 2D array.You can then auto index every row of the output array.DaveMessage Edited by DavidU on 06-20-2008  03:31 PM


col1 with every value of col2.vi:
http://forums.ni.com/attachments/ni/170/333596/1/col1 with every value of col2.vi


col1 with every value of col2.PNG:
http://forums.ni.com/attachments/ni/170/333596/2/col1 with every value of col2.PNG
0
x9561 (148440)
6/20/2008 2:40:06 PM
Dear Dave
Thank you for ur reply, but I cannt see ur code, as I use Labview version 8.2.1
Jing
0
x9561 (148440)
6/20/2008 3:40:06 PM
Try this. Dave


col1 with every value of col2 - v82.vi:
http://forums.ni.com/attachments/ni/170/333618/1/col1 with every value of col2 - v82.vi
0
x9561 (148440)
6/20/2008 3:40:06 PM
thank you again!!!
Can these two array have different number of data
I mean for example, the first array has 6 data, and the second array has 3 data?
Jing
0
x9561 (148440)
6/20/2008 3:40:09 PM
Do you mean the input and output arrays or the 2 columns of the input array.If you mean the input and output arrays then the size of the output array is determined by the size of the input array, so you would have to do some post-processing to resize the output array.If you mean the 2 columns of the input array then yes you can but you would have to use 2 seperate 1D arrays, 1 for each column. You cannot have different length columns in a 2D arraySee the attached viDaveMessage Edited by DavidU on 06-20-2008  04:57 PM


col1 with every value of col2 - 1D inputs - v82.vi:
http://forums.ni.com/attachments/ni/170/333639/1/col1 with every value of col2 - 1D inputs - v82.vi
0
x9561 (148440)
6/20/2008 4:10:08 PM
Dear Dave
&nbsp;
Thank you so much!!!
&nbsp;
Jing
0
x9561 (148440)
6/20/2008 8:40:06 PM
Reply:

Similar Artilces:

Keithley 617 lag in Labview VI's reading of data + repeats same data every 100 pnts
Please help. Ive been struggling with this for months now, before i found this site. No one in this studpi dept is able to help me. I have the VI's, if you want to see them, i can email them. I have the Keithley 617 reading data from a photomultiplier tube (PMT) and it is interfaced with a GPIB card to a 500 mhz pentium computer with Labview on it. I modified the two VI's given to me (one spits data in an array with up to 100 points per cycle and one reads data one by one, up to 14 bytes). My coding modifications is good i think, as people here who know more about Labview than i ...

reading data in a text file column-by-column
OK let us suppose I have a text file (*.txt or *.dat) in which the data is as follows: 1 100 1 1 2 1. 28.342 2 100 1 1 0.944 20.123 3 100 1 1 3 0.9 0. Now I want to read from this text file and store the data in each column in a separate matrix. For example, If I am able to store the first column into a matrix "item_no", the matrix shall be like [1 2 3] and the second column can be stored into a matrix "Quantity" and will look like [100 100 100]. Can someone please help me out on this? I have a project and I cannot proceed further witho...

How to diplay the data in column after reading and displaying the next data?
I have a vi that reads the data and display it multicolumn listbox one by one after reading, but before it display the data, the first data in column must be be erased firs before it display the next data. i want all data to be displayed 1 by 1 without deleting the first entry data. Thank You Very Much. ...

Averaging the second column of data for many sets of data
Hi all, I was recently reading: http://www.mathworks.com/matlabcentral/newsreader/view_thread/304172 I have a similar situation but can't figure out how to do something very seemingly simple... I have a program that generates a .mat file which has a single variable inside. This variable is a 64x2 matrix and the first column values never change. All of the .mat files have unique names, and I'd like to add a for loop to my program that can average the second column of data across all these individual files. The final output would be another .mat file with the averaged values...

How to insert/update a column with text data with other columns in a table?
Hi, How should we insert/update a (text data) column in a table? I have a table &#8220;Server&#8221; (Server Name, IP Address, System_Info). The &#8220;System_Info&#8221; column contains several rows of data. On the other side the &#8220;Server Name&#8221; & &#8220;IP Address&#8217; column contain only one row. I was trying to insert/update the &#8220;System_Info&#8221; column via SQLLOADER but I didn&#8217;t get the desired results. Could some one suggest how should we insert or update the column like &#8220;System_Info&#8221; in a ...

Data, data, data,
I have been tasked to dump around 400GB of data in physical files into a flat files and the transfer them from an iSeries 810 V5r3 to a windows server. I was going to CPYTOIMPF to a stram file and then copy over to the Windows server from the IFS. Anyone have a better idea or any suggestions? Thanks, Thad Rizzi Hi Thad If you have loads of free disk space on your 810 then your method is fine but if not you may consider Simply FTPing or iSeroes Access file transfering the files directly from the iSeries files to Windows Text file. You can get the either FTP or iSeries Access to carry out...

get data every 2 columns at a time in excel
i would like to read the following excel file and plot every 2 columns at one time given an interval. for example at 7 am i ll plot corresponding I and V and at 8 am so on.. but even though i programmed my VI to read by increasing index 0,2,4 so on it stops when it iterates half way i.e i=12..this only plots half the data..im reading from delimited text file..how can i read from a true xls file and plot all the data as desired? table.xls: http://forums.ni.com/attachments/ni/170/318689/1/table.xls table mode.vi: http://forums.ni.com/attachments/ni/170/318689/2/table mode.vi <a href="http://forums.ni.com/ni/board/message?board.id=170&amp;view=by_date_ascending&amp;message.id=318690#M318690" target="_blank">Duplicate Post</a> ...

Using Cobol
Hi, I have a requirement as follows: I have a COBOL+DB2 program that inserts data into a DB2 table when an order is placed. Now, The same data should be inserted into the same table after every 7 days until a condition is met. This means I need to insert same data after every 7 days until the order is approved/ denied. Any help would be highly appreciated. Thanks, Raya. On Apr 9, 7:46 am, "Raya" <lakshmir...@gmail.com> wrote: > Hi, > I have a requirement as follows: > > I have a COBOL+DB2 program that inserts data into a DB2 table when an > order is placed. ...

get data every 2 columns at a time in excel #2
i would like to read the following excel file and plot every 2 columns at one time given an interval. for example at 7 am i ll plot corresponding I and V and at 8 am so on.. but even though i programmed my VI to read by increasing index 0,2,4 so on it stops when it iterates half way i.e i=12..this only plots half the data..im reading from delimited text file..how can i read from a true xls file and plot all the data as desired? table1.xls: http://forums.ni.com/attachments/ni/170/318690/1/table1.xls table mode1.vi: http://forums.ni.com/attachments/ni/170/318690/2/table mode1.vi You have a&nbsp;few problems in your code that need to be resolved first. 1.&nbsp; You posted and Excel .xls file.&nbsp; A true spreadsheet file.&nbsp; The read from spreadsheet file VI doesn't work with Excel files, it only works with text files. 2.&nbsp; Your run the loop 25 times.&nbsp; It asks for the file 25 times because the file control is inside the loop.&nbsp; Also, any loop should only run 13 times, because you have 13 pairs of columns. 3.&nbsp; You only have&nbsp;10 rows of data.&nbsp; The first couple are headers you want to ignore. 4.&nbsp; After the last iteration, you will only have the results from the last pair of columns because the array indicator and XY graph are inside the loop.&nbsp;(Though I see you have a 2000 msec wait, so you will see the results of each column pair with a 2 second pause between them.) Overall you have to...

how to store more data in data base column
hi &nbsp; i want to store 801 values in one column of data base. i tried but i was able to store/write only 10 values.can any boly help me in this matter........ I think this is the same topic. <a href="http://forums.ni.com/ni/board/message?board.id=170&amp;thread.id=322818&amp;jump=true" target="_blank">continue here</a> Is this part of a class project?&nbsp; There are two similar questions from different users. &nbsp; How were the fields defined in your database?&nbsp; Will it support 801 values? How many characters are allowed in that field?&nbsp;(ie 801 X #of characters in each data points)? &nbsp; RayR ...

Reading controller data into LabVIEW through serial connections to controllers?
I'd like to read data from environmental chamber controllers (System Plus) into LabVIEW through RS232 connections.&nbsp; Has anyone done something similar? &nbsp;I see interfacing with the serial controllers as the biggest obstacle and although not directly related to LabVIEW programming, I'm hoping someone here can give me some advice or resources on how best to do so now days. &nbsp;My first thought is to write a program with VB or C++ to act as a terminal and write the data to a text file for LabVIEW to poll.&nbsp; Aside from using Telix decades ago to work with BBSes, my only other serial experience consists of interfacing with a Kiethly multimeter using a C++ program.&nbsp; &nbsp;I would rather not use multiple PCs but I have never worked with more than one serial port on a computer before in the past.&nbsp; Perhaps LabVIEW itself already provides for multiple serial card communications (wouldn't that be perfect)? &nbsp;Any info would be great. &nbsp;Regards, &nbsp;Dave&nbsp;&nbsp; LabVIEW has had support for serial communication for as long as I've used it and may have been part of version 1. It also supports multiple serial ports&nbsp;- built-in and USB-&gt;RS232. There are even a couple of shipping examples. I've not used this particular chamber but I've used several with serial connections. It's a matter of getting the programming manual and working through it if a driver does not al...

Log data every 20 seconds with duration of 10 seconds
I am using Labview 8.20 on&nbsp;WinXP&nbsp;and trying to log data every 20 seconds with duration of 10 seconds. The hardware I am using is NI cDAS-9172 with NI 9237, NI 9205.&nbsp;I know it must be a simple programming, but I am just a beginer and need this&nbsp;shortly.&nbsp;&nbsp;The attached vi file I wrote&nbsp;could not do what I want. Somebody please help me out. Thanks alot.&nbsp; Timed Log_3.vi: http://forums.ni.com/attachments/ni/170/313247/1/Timed Log_3.vi I only took a brief look at your VI, but right off the bat, you need to get rid of your inner loop. The way it is once the "time to log" comes up you go into the inner loop and don't get out of the inner loop until the second elapsed time has happened. During this time you are not acquiring data - you're always logging the same value for 10 seconds.. Attached is an alternate implementation using simulated data. The string control acts as the data that's going to be logged. It's crude, but I'll leave it to you to "spiff it up" or think of a more elegant solution. :smileywink: Elapsed Time Ex.vi: http://forums.ni.com/attachments/ni/170/313255/1/Elapsed Time Ex.vi ...

converting 1 column data into 2 columns
This should be an easy puzzle to solve. I have data in the following format: 1 1 2 2 2 3 4 4 6 7 7 What I want is to convert the data so that the first column shows the data, and the second number shows the number of occurrences (I'm going to feed it to gnuplot). So the converted file should look like this: 1 2 2 3 3 1 4 2 6 1 7 2 Any help would be appreciated. TIA, tropicflite tropicflite wrote: > This should be an easy puzzle to solve. I have data in the following > format: > > 1 > 1 > 2 > 2 > 2 > 3 > 4 > 4 > 6 > 7 > 7 > > What...

Match data in columns and add additional data
I'd like to match a column of data between two datasets and if there is a match add a new piece of information from the second to the first. Probably easier to explain in example- I have cell arrays at the moment: A={'Adam',2;'Bill',3} B={'David',123;'Chris',456;'Bill',789} I would like to return: newA={'Adam',2,0;'Bill',3,789} So I'd like to see if there is a match in the 'name' columns, and if there is, add information from B to the corresponding row in A. The 0 for Adam in the third column is a placeholde...

replace missing data with data from another column
Hello Everyone, I know there has to be an easy way to do this but I have been having a dickens of a time trying to write a syntax for this. I have two columns of data (diagnosis codes) and in the first column some of the diagnosis codes is missing for some of the cases. What I would like to do is take the diagnosis codes from the subsequent column and include them in the first column of diagnosis codes only for cases that are missing that first diagnosis codes, the data looks something like this: Diagnosis1 Diagnosis2 I would then like it to look like this: Diagnosis1 310.2 310.2 310.2 .. 850.00 850.00 800.01 800.01 800.01 959.01 959.01 959.01 .. 854.01 854.01 .. 803.00 803.00 Any help with this would be greatly appreciated!! On Nov 5, 12:49=A0pm, athenakrobb...@gmail.com wrote: > Hello Everyone, > > I know there has to be an easy way to do this but I have been having a > dickens of a time trying to write a syntax for this. I have two > columns of data (diagnosis codes) and in the first column some of the > diagnosis codes is missing for some of the cases. What I would like to > do is take the diagnosis codes from the subsequent column and include > them in the first column of diagnosis codes only for cases that are > missing that first diagnosis codes, the data looks something like > this: > > Diagnosis1 Diagnosis2 =A0I would then like it to look like this: > Diagnosis1 > 310.2 >...

Read data in more than one column
I have datas in a file with 26 columns. In first columns there are day of year, in second there are dates and in the remaining columns there are values of temperature. I don't get read these datas starting third columns. Can you help me, please? On 08/13/15 11:24, Joyrles Fernandes wrote: > I have datas in a file with 26 columns. In first columns there are > day > of year, in second there are dates and in the remaining columns there > are values of temperature. I don't get read these datas starting third > columns. Can you help me, please? Not enough informatio...

xml data to columns table
Hi all, Assuming i have this xml fragment, stored in a column named xmldata of CLOB type, in a table '<Warehouse> <WarehouseId>1</WarehouseId> <WarehouseName>Montreal, Quebec</WarehouseName> </Warehouse> <Warehouse> <WarehouseId>2</WarehouseId> <WarehouseName>Southlake, Texas</WarehouseName> </Warehouse> ' How can i generate in one query, the xml elements to have them in columns table format ? I know, i could do something like select extractvalue(a.xmldata,'//Warehouse/WarehouseId') id, extractvalue(a.xmldata,'//Warehouse/WarehouseName') name from mytable a Result ------- id name 1 Montreal, Quebec 2 Southlake, Texas and that would satisfy my needs. But, what if i have many more xmlelements inside my xml ? I wouldn't like to select each column by each column as above. In fact, i'm looking something equal to the "select *" but from an xmldata so that it is directly splitted into the right number of columns, based on the xml elements. Is that clear for anybody ..? Thanks for helping, Regards, Mike. ...

read data skipping column
Dear all, I need your help to read a unfriendly formatted ascii file which contains some data I have to analyze. The file looks like the following (delimiter is a number of blank spaces not tab): header 1 header 2 .... header N 10:39 data11 data12 data13 data14 data11 data12 data13 data14 data11 data12 data13 data14 data11 data12 data13 data14 10:40 data11 data12 data13 data14 data11 data12 data13 data14 data11 data12 data13 ...

Collect Data from corresponding Columns
I have 3 vectors with data in them: Time, Variable A, Variable B I have time listed as a character, but what I want to be able to do is type in two boundary time points so then the data that is within the time boundaries from vector Variable A or B can be collected and analyzed. Essentially, I want to collect the data from the corresponding time columns as set by the boundary times I have typed in. Example below: data01.txt has the following information Time Variable A Variable B 00:01 4 3 00:03 5 3 00:09 6 4 00:11 5 3 00:12 6 7 00:15 6 4 00:18 4 6 00:22 6 3 I created a struct that holds each of these variable (ex. data01.Time). Now I want to add the appropriate code that would allow me to type in a lower time boundary (ex. 00:01) and upper time boundary (ex. 00:11) and collect the data from data01.VariableA or data01.VariableB between these times and add them to new vectors. If anyone could help that would be great! On 08/02/2014 12:37 PM, D Gal wrote: > I have 3 vectors with data in them: Time, Variable A, Variable B > > I have time listed as a character, but what I want to be able to do is > type in two b...

Copy data from one table to another table with change in identity column values
HI, I have a table Create table test(a int identity(1,1), b int) insert into test(b) values(12) insert into test(b) values(30) insert into test(b) values(65) insert into test(b) values(78) insert into test(b) values(36) o/p a b 1 12 2 30 3 65 4 78 5 36 i need to copy the table into another table with creating the new table we had a option select * into newtable from oldtable here the data in the oldtable will e copied to new table without creating new table but i need to copy the data as shown below with out creating new table o/p a b 11 12 12 30 13 65 14 78 15 36 Thanks, Sat...

Query to Always Provide Data from First Table With Optional Values From Second Table
I have two tables that has the following data: NameTable: ID Name ----------- 1 foo 2 bar 3 doe 4 john NotesTable: ID Date Value ---------------------------------- 1 6/9/06 "test 1" 1 6/9/06 "test 2" 2 6/1/06 "" 2 6/2/06 " " 3 6/9/06 "test 3" Where NameTable.id = NotesTable.id And I want the query to return the following. Note that values that are null, zero length, or nothing but spaces are not included in the results, but "bar" and "john" are still listed at least once in the results. Name Date Value ---------------------------- foo 6/9/06 "test 1" foo 6/9/06 "test 2" bar null null doe 6/9/06 "test 3" john null null O.B. napsal(a): > I have two tables that has the following data: > > NameTable: > > ID Name > ----------- > 1 foo > 2 bar > 3 doe > 4 john > > NotesTable: > > ID Date Value > ---------------------------------- > 1 6/9/06 "test 1" > 1 6/9/06 "test 2" > 2 6/1/06 "" > 2 6/2/06 " " > 3 6/9/06 "test 3" > > Where NameTable.id = NotesTable.id > > And I want the query to return the following. Note tha...

Add one column based on the data in another column
G'day, Everyone! I have this data file. This was summarized from bigger file for test simulation. aaa.txt 01 -999.9 02 -999.9 03 -999.9 04 0.13 05 -999.9 06 -999.9 07 0.17 08 -999.9 09 -999.9 10 -999.9 11 -999.9 12 -999.9 13 -999.9 14 -999.9 15 -999.9 I am making another column based on 2nd column with these criteria. 1) All five lines should have the same value. 2) This value is come from 2nd column and should be 0 < value < 1. 3) If no value is in this range, (i.e. 11~15th lines above), just copy the values from 2nd column. This is my target array. 01 -999.9 0.13 02 -999.9 0...

Re: Split data from one column to multiple column
On Wed, 20 Dec 2006 01:28:04 -0800, lucky <luckylnv@GMAIL.COM> wrote: >Dear all, > >My Query is i have to split data into multiple column >like i have one variable abc in this variable data in 4 digit like 1234 >then i have to change 1 char in one column sec char in to sec column >and 3,4 in single column it means i have to split 4 digit data into >three varible plz send me the reply Hi, data out; input number; length var1 $1; length var2 $1; length var3 $2; var1 = substr(put(number,4.),1,1); var2 = substr(put(number,4.),2,1); var3 = substr(put(number,4.),3,2); datalines; 1234 5678 ; proc print; run; and please (not "plz") see if you can phrase your questions better in the future, preferably with some test data, and punctuation in the text. Thanks! ...

the data that is in the table is from excel, so the data to be read can changed?
for example the data before is EXEC 1,how if i'll changed the value to 1 how can i read those data if he changed the EXEC 1 to 1. that's why i said the data is changeable. can you give me a simple example about this? Thank You thank you for your help, but how if EXEC 1 can be EXECUTE 1 of EXE 1. I use the scan from string and it only reads EXEC, EXECUTE and EXE not 1 and space. Either EXECUTE 1, EXEC 1, EXE 1 and 1 can be the value that can get from excel. The string parse example is working at LV 7.0, I'm using LV 6.1. ...

Web resources about - How to read every data in the first column corresponding to the every data in the second column in the TABLE CONTROL? - comp.lang.labview

Supporters, protesters clash outside Trump rally in Utah
SALT LAKE CITY (AP) — Protesters clashed with supporters of Donald Trump after he gave a speech in Utah on Friday, ending a day full of presidential ...

Paris attacks suspect Salah Abdeslam leaves Brussels hospital
Key Paris attacks suspect Salah Abdeslam and an accomplice on Saturday left the Brussels hospital where they were treated overnight for gunshot ...

IL County Attorney on Extraordinary Court Order Mandating 'Late Voting' Next Week in Adams: 'BradCast' ...
I'm joined on today's BradCast by Adams County, IL State's Attorney Jon Barnard to discuss the extraordinary court order [PDF] issued just last ...

Jury awards Hulk Hogan $115 million in Gawker sex tape suit
ST. PETERSBURG, Fla. (AP) — A Florida jury sided with ex-pro wrestler Hulk Hogan and awarded him $115 million in his sex tape lawsuit against ...

Minecraft Gets Samsung Gear VR Treatment, New Headset Impresses At Game Developers Conference
More Minecraft fans will find it more difficult to stay away from their games once the title has been fully ported to the Samsung Gear VR, and ...

Microsoft Wants To Get Chrome Extensions Working On Edge
In the latest Windows 10 test build, Microsoft finally introduced extensions to its Edge browser . Not many are available right now, but we suppose ...

Drone Comes Within 200 Feet Of Passenger Jet Coming In To Land At LAX
LOS ANGELES (Reuters) - The pilot of a Lufthansa passenger jumbo jet reported a drone aircraft nearly collided with the airliner on Friday on ...

Spartans, other upsets mean time to reboot NCAA Tournament
ST. LOUIS (AP) — Nobody wants an NCAA Tournament mulligan more than Michigan State.

EU Braced for Refugee Setbacks as Turkey Deal Meets Skepticism
Bloomberg EU Braced for Refugee Setbacks as Turkey Deal Meets Skepticism Bloomberg A woman sits on the side of a road after being detained ...

Twitter Sticks To 140-Character Limit
Twitter CEO Jack Dorsey made an appearance on The Today Show today in order to celebrate the micro-blogging company’s 10th anniversary. While ...

Resources last updated: 3/19/2016 9:33:43 AM