The Origin Forum - Compare colums, remove some rows

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum

Compare colums, remove some rows

New Topic

Reply to Topic

Printer Friendly

Author

Topic

holzi13

1 Posts

Posted - 10/17/2012 : 04:36:33 AM

Origin Ver. and Service Release (Select Help-->About Origin): 8.1
Operating System: Win XP

Hi,
i hope you can help. I have the following problem/question:

I have two output files and need to compare this.
In the first file are time vs. temperature, the other file time vs. Data. But the time-values are not always exactly the same (due to some some different interval) . For example (simplified)

Time1 Temp. Time2 Data

9:00:01 100 9:00:00 x1
9:00:02 100 9:00:01 x2
9:00:02 101 9:00:02 x3
9:00:03 101 9:00:03 x4
9:00:03 101 9:00:04 x5
9:00:04 101 9:00:05 x6
9:00:05 102 9:00:06 x7
9:00:05 103 9:00:07 x8
9:00:06 104 9:00:08 x9
9:00:07 105 9:00:08 x10
9:00:09 107 9:00:09 x11
...

Now i need colums: Temp. vs Data. The problem is, some Time-values in a row are twice, maybe some are missing. If i have more time/temp. values than time/data values i need to remove some time/temp.-rows. Finally i need temp/data colums.
I have a lot of files and each file can have more than 1000 values, so it would be great if i can get something like a "script" for this.

thanks in advance for help,

Harald

Drbobshepherd

USA
Posts

Posted - 10/17/2012 : 10:17:03 AM

holzi13,

1. Separate the X-Y data sets into two sheets using newsheet, and colmove.

2. Use wdelrows on each sheet to remove rows with missing data.

3. Use wdeldup on each sheet to delete rows with duplicate values.

This should resolve your missing data and duplicate data issues.

DrBobShepherd

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000