10 More Discussions You Might Find Interesting
1. 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
2. Programming
Dear community,
could someone help me to join 2 queries into one?
Basically it's the same query with different clauses (please notice the FIELD3 filters and related counters into the subquery):
SELECT A.FIELD1,A.FIELD2,A.FIELD3
FROM
TABLE A
INNER JOIN
(
SELECT FIELD1,... (3 Replies)
Discussion started by: Lord Spectre
3 Replies
3. UNIX for Dummies Questions & Answers
Hello.. I am trying to join two files of about 7000 records. it looked quite straight forward when i began, but i'm not getting the desired output.
here is what i'm trying to do:
cat xxx
item,So,Mo,Tu
aaa,1,1,1
bbb,1,1,4
ccc,1,1,0
ddd,1,1,1
cat yyy
item,Tu,We
aaa,1,1
bbb,4,0... (7 Replies)
Discussion started by: wanderingmind16
7 Replies
4. 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
5. UNIX for Dummies Questions & Answers
dear friends,
attached are two sorted files. I want to merge them using key column: Column #2 in first file and column #1 in the second file. I want to show all columns in the merged output file.
my code used is:
join -a1 -a2 -1 2 -2 1 -o 1.1 1.2 1.3 2.1 uncontrols2_by_ilmn_gene.txt... (4 Replies)
Discussion started by: forevertl
4 Replies
6. Programming
Hi,
I have 2 tables.
Table1
name map_code data_code id
aaa 2732C 3333B 10
bbb 1223F 2545v 11
ccc 12
Table2
name map_code data_code id text_description
aaa 2732C 3333B 10 description 1
bbb 1223F 2545v 11 ... (3 Replies)
Discussion started by: vanitham
3 Replies
7. Programming
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
8. 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
9. Programming
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
10. 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
DBIx::Class::SQLMaker::OracleJoins(3) User Contributed Perl Documentation DBIx::Class::SQLMaker::OracleJoins(3)
NAME
DBIx::Class::SQLMaker::OracleJoins - Pre-ANSI Joins-via-Where-Clause Syntax
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
Not intended for use directly; used as the sql_maker_class for schemas and components.
DESCRIPTION
Implements pre-ANSI joins specified in the where clause. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the sql query, it's already too late.
METHODS
select
Overrides DBIx::Class::SQLMaker's select() method, which calls _oracle_joins() to modify the column and table list before calling
next::method().
BUGS
Does not support full outer joins (however neither really does DBIC itself)
SEE ALSO
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Storage class using this
DBIx::Class::SQLMaker - Parent module
DBIx::Class - Duh
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.18.2 2014-01-22 DBIx::Class::SQLMaker::OracleJoins(3)