Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: UNIX outer join
Top Forums UNIX for Dummies Questions & Answers UNIX outer join Post 302859171 by alister on Wednesday 2nd of October 2013 01:23:57 PM
Old 10-02-2013
The join field can always be included in the output format, even when it doesn't appear in one of the files, by using 0 instead of 1.x or 2.y.
Code:
$ cat file1
item,So,Mo,Tu
aaa,1,1,1
bbb,1,1,4
ccc,1,1,0
ddd,1,1,1

$ cat file2
item,Tu,We
aaa,1,1
bbb,4,0
eee,0,1
fff,0,2

$ join -t, -a1 -a2 -e0 -o0,1.2,1.3,1.4,2.3 file1 file2
item,So,Mo,Tu,We
aaa,1,1,1,1
bbb,1,1,4,0
ccc,1,1,0,0
ddd,1,1,1,0
eee,0,0,0,1
fff,0,0,0,2

Regards,
Alister
Last edited by alister; 10-02-2013 at 02:45 PM..
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

unix join !

just wandering if anyone knows what kind of algorithm unix join command is using to join 2 files. Thanks! (2 Replies)
Discussion started by: strike
2 Replies

2. Programming

Oracle: fixing an outer join on subquery...

I have a stored procedure that is failing. The current query behind it is: SELECT DISTINCT <many, many values> FROM table1 LEFT OUTER JOIN table2 ON (table2.key = (select max (table2.key) from table2 where table2.key = table1.key) or ... (0 Replies)
Discussion started by: Elric of Grans
0 Replies

3. Programming

sql,multiple join,outer join issue

example sql: select a.a1,b.b1,c.c1,d.d1,e.e1 from a left outer join b on a.x=b.x left outer join c on b.y=c.y left outer join d on d.z=a.z inner join a.t=e.t I know how single outer or inner join works in sql. But I don't really understand when there are multiple of them. can... (0 Replies)
Discussion started by: robbiezr
0 Replies

4. Shell Programming and Scripting

How can i join three lines into one in unix?

Hi all, I am trying to merge three lines into one in my unix text file. My text file sis omething like this. xxxxxxxxx yyyyyyyyyyy zzz aaaaaaaaa bbbbbb ccccc Expected out put is xxxxxxxxx yyyyyyyyyyy zzz aaaaaaaaa bbbbbb ccccc I tried with awk as shown below. (23 Replies)
Discussion started by: rdhanek
23 Replies

5. Programming

OUTER join?

Hi, I have a code where it traverses through each record froma table and creates records in another table. I use FOREACH cursor to do this, i'm using another cursor inside the FOREACH to fetch the details of other table. Please suggest me which would be more efficient, as this will run against... (2 Replies)
Discussion started by: dvah
2 Replies

6. Shell Programming and Scripting

Unix Join

Hi, I am trying to join two simple files but unable to do so properly. File R1 : 100 101 102 105 . . 1000 10001 File R2 100|x1 102|x2 1000|a1 10001|a2 and when i do (4 Replies)
Discussion started by: wanderingmind16
4 Replies

7. UNIX for Dummies Questions & Answers

how to join all lines in afile in unix

Hi, I have a unix file which has many lines, i need to join all the lines to single line. Eg: myfile.txt contains: a 123 45fg try and i need the output as : a 123 45fg try Please help me on this. Thanks! (2 Replies)
Discussion started by: RP09
2 Replies

8. Shell Programming and Scripting

Break the outer loop

Hi I'm comparing same files names which are in different folders . The first for loop for the files in DAY1 folder and the second for loop for the files in DAY2 folder . the first IF condition is for checking whether the file names are equal the second If condtion is for checking the... (4 Replies)
Discussion started by: smile689
4 Replies

9. Shell Programming and Scripting

How to join two different file in UNIX?

Hello folks I have 2 files which are like this: file (a): id phenotype 100 1.2 200 -0.5 300 3.1 file (b) id genotype 100 0 1 2 ...... 200 1 1 1...... 300 2 0 0 ....... I should mention in file (a) I have 2... (3 Replies)
Discussion started by: sajmar
3 Replies

10. Shell Programming and Scripting

UNIX Join not working as expected

Hello All, I'm working on a Shell script to join data from two files using Join command but not able to get the desired output as its throwing me an error: I have sorted the two files on the Column 1 numerically which is used as Join clause File 1: 1,ABC,GGG,20160401 2,XYZ,KKK,20160401... (2 Replies)
Discussion started by: venkat_reddy
2 Replies

LEARN ABOUT DEBIAN

nuaclgen

NUACLGEN(8)															       NUACLGEN(8)

NAME

       nuaclgen - NUFW acl generator

SYNOPSIS

       nuaclgen  [  --Schema eq|ineq ] [ --Aclname ACLDN ] [ --saddr NETWORK1 ] [ --daddr NETWORK2 ] [ --proto PROTONUMBER ] [ --sport P1[:P2] ] [
       --dport P3[:P4] ] [ --OsName OSNAME ] [ --OsVersion OSVERSION ] [ --OsRelease OSRELEASE ] [ --AppName APPLICATION NAME ] [ --AppSig  APPLI-
       CATION SIGNATURE ] [ --Separator SEPARATOR ] [ --jump [ACCEPT|DROP] ] [ --groups GROUPLIST ]

       nuaclgen [ --List ] [ --groups Id Group ]

       nuaclgen [ --Delete DN ]

       nuaclgen [ --help ]

DESCRIPTION

       This manual page documents the nuaclgen command.

       nuaclgen is an Access control list generator for the ldap backend of Nuauth, the authentication server of the NUFW package.

       Original packaging and informations and help can be found from http://www.nufw.org/

OPTIONS

       --Schema eq|ineq
	      Use equality schema or not (Equality schema requires dport be specified, and is the default.

       --AclName Acl DN
	      Add an acl in the ldap tree with dn Acl DN

       --saddr Network
	      Specify source network for the acl, with network of the form : aaa.bbb.ccc.ddd[/ee]. Default value : 0.0.0.0/0

       --daddr Network
	      Specify destination network for the acl, with network of the form : aaa.bbb.ccc.ddd[/ee]. Default value : 0.0.0.0/0

       --proto Protocol number
	      Specify protocol type for the acl

       --sport Source port
	      Specify source port(s) for the Acl. NNNN:MMMM can be used to specify a port range.

       --dport Destination port
	      Specify destination port(s) for the Acl. NNNN:MMMM can be used to specify a port range.

       --jump Decision
	      Specify decision for the Acl. Has to be ACCEPT or DROP.

       --groups Groups list
	      Specify the user group(s) on which Acl apply. Must be of the form : Group1[,Group2[,...]]

       --List --group Group ID
	      List Acls for the Group ID group

       --Delete Dn
	      Deletes the Acl stored in the provided Dn

       --help Displays a brief resume of available options and quits

SEE ALSO

       nufw(8)

       nuauth(8)

AUTHOR

       Nuauth  was designed and coded by Eric Leblond, aka Regit (<eric@regit.org>) , and Vincent Deffontaines, aka gryzor (<vincent@gryzor.com>).
       Original idea in 2001, while working on NSM Ldap support.

       This manual page was written by Eric Leblond and copyrighted by INL (2003-2005)

       Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version  2	as
       published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts and no Back-Cover Texts.

								   12 mars 2007 						       NUACLGEN(8)
All times are GMT -4. The time now is 05:08 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy