08-13-2002
using join command for files
Hi,
I have to join 2 files based on two key field columns.
But join command allows to give only one key column for fetching.So kindly update me whether i can compare 2 files based on two key columns or more than one key column.If so what is the syntax to compare it.
With thanks in advance,
subra.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am trying to use join command for two files of size greater than 1 GB.
join -t , -1 2 -2 1 -o 1.1,1.2,1.3,1.4,1.5,1.6,1.7,1.8,1.9,1.10,1.11,1.12,1.13,1.14,1.15,1.16,1.17,1.18,1.19,1.20,1.21,1.22,1.23 File1 File2 > File3
we are facing space crunch after using these join command.
May i... (0 Replies)
Discussion started by: jerome Sukumar
0 Replies
2. OS X (Apple)
I need a simple command line executable that allows me to join many wmv files into one output wmv file, preferrably in a simple way like this:
wmvjoin file1.wmv file2.wmv .... > outputfile.wmv
So what I want is the wmv-equivalent of mpgtx
I cannot find it on internet.
Thanks. (2 Replies)
Discussion started by: karman
2 Replies
3. Shell Programming and Scripting
Hi,
I am a new learner of join command. Some result really make me confused.
Please kindly help me.
input:
file1:
LEO oracle engineer 210375
P.Jones Office Runner ID897
L.Clip Personl Chief ID982
S.Round UNIX admin ID6
file2:
Dept2C ID897 6 years
Dept5Z ID982 1 year
Dept3S ID6 2... (1 Reply)
Discussion started by: summer_cherry
1 Replies
4. UNIX for Dummies Questions & Answers
Hello,
My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns:
File A: (tab-delimited)
PDB CHAIN Start End Fragment
1avq A 171 176 awyfan
1avq A 172 177 wyfany
1c7k A 2 7... (3 Replies)
Discussion started by: InfoSeeker
3 Replies
5. Shell Programming and Scripting
input1
a_a a/a 10 100
a1 a_a 20 200
b1 b_b 30 300
input2
a_a a/a xxx yyy
a1 a1 lll ppp
b1 b_b kkk ooo
output
a_a a/a 10 100 xxx yyy (2 Replies)
Discussion started by: ruby_sgp
2 Replies
6. Shell Programming and Scripting
We have two files with results of two commands of cisco:
one file; showintstatus, have the following format:
Gi2/6 servidorlij connected 176 full 1000 10/100/1000BaseTsecond file; showmacaddrestable, have the following format:
* 162 0021.9b8d.073e dynamic Yes 0 ... (1 Reply)
Discussion started by: robonet
1 Replies
7. UNIX for Dummies Questions & Answers
file1:
Toronto:12439755:1076359:July 1, 1867:6
Quebec City:7560592:1542056:July 1, 1867:5
Halifax:938134:55284:July 1, 1867:4
Fredericton:751400:72908:July 1, 1867:3
Winnipeg:1170300:647797:July 15, 1870:7
Victoria:4168123:944735:July 20, 1871:10
Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies
8. UNIX for Dummies Questions & Answers
How do you use the join command and obtain tab delimited text files as an output? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column).
I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies
10. Shell Programming and Scripting
Hello,
This post is already here but want to do this with another way
Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv:
1|123|jojo
1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies
LEARN ABOUT DEBIAN
alzabo::create::foreignkey
Alzabo::Create::ForeignKey(3pm) User Contributed Perl Documentation Alzabo::Create::ForeignKey(3pm)
NAME
Alzabo::Create::ForeignKey - Foreign key objects for schema creation.
SYNOPSIS
use Alzabo::Create::ForeignKey;
DESCRIPTION
A foreign key is an object defined by several properties. It represents a relationship from a column or columns in one table to a column
or columns in another table.
This relationship is defined by its cardinality (one to one, one to many, or many to one) and its dependencies (whether or not table X is
dependent on table Y, and vice versa).
Many to many relationships are not allowed. However, you may indicate such a relationship when using the Alzabo::Create::Schema->add_rela-
tion method method, and it will create the necessary intermediate linking table for you.
INHERITS FROM
"Alzabo::ForeignKey"
Note: all relevant documentation from the superclass has been merged into this document.
METHODS
new
The constructor takes the following parameters:
* columns_from => "Alzabo::Create::Column" object(s)
* columns_to => "Alzabo::Create::Column" object(s)
These two parameters may be either a single column or a reference to an array columns. The number of columns in the two parameters
must match.
* cardinality => [1, 1], [1, 'n'], or ['n', 1]
* from_is_dependent => $boolean
* to_is_dependent => $boolean
* comment => $comment
An optional comment.
It returns a new "Alzabo::Create::ForeignKey" object.
Throws: "Alzabo::Exception::Params"
table_from
table_to
Returns the relevant "Alzabo::Create::Table" object.
columns_from
columns_to
Returns the relevant "Alzabo::Create::Column" object(s) for the property as an array.
column_pairs
Returns an array of array references. The references are to two column array of "Alzabo::Create::Column" objects. These two columns cor-
respond in the tables being linked together.
set_columns_from ("Alzabo::Create::Column" object(s))
Sets the column(s) that the relation is from. This can be either a single column object or a reference to an array of column objects.
Throws: "Alzabo::Exception::Params"
set_columns_to ("Alzabo::Create::Column" object(s))
Sets the column(s) that the relation is to. This can be either a single column object or a reference to an array of column objects.
Throws: "Alzabo::Exception::Params"
cardinality
Returns a two element array containing the two portions of the cardinality of the relationship. Each portion will be either '1' or 'n'.
from_is_dependent
to_is_dependent
Returns a boolean value indicating whether there is a dependency from one table to the other.
is_one_to_one
is_one_to_many
is_many_to_one
Returns a boolean value indicating what kind of relationship the object represents.
set_cardinality (@cardinality) see above for details
Sets the cardinality of the foreign key.
Throws: "Alzabo::Exception::Params"
set_from_is_dependent ($boolean)
Indicates whether or not the first table in the foreign key is dependent on the other (i.e. whether the 'from' table is dependent on the
'to' table).
set_to_is_dependent ($boolean)
Indicates whether or not the second table in the foreign key is dependent on the other (i.e. whether the 'to' table is dependent on the
'from' table).
id
Returns a string uniquely identifying the foreign key.
is_same_relationship_as ($fk)
Given a foreign key object, this returns true if the two objects represent the same relationship. However, the two objects may represent
the same relationship from different table's points of view.
comment
Returns the comment associated with the foreign key object, if any.
set_comment ($comment)
Sets the comment for the foreign key object.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Create::ForeignKey(3pm)