Questions tagged [join]

Command line utility to join lines of two files

0
votes
0answers
17 views

I have a query of 5 tables and about 120,000 rows of outputs. How can I display them in the grid for high performance? sqlserver optimize

I have a query of 5 tables and about 120,000 rows of outputs. How can I display them in the grid for high performance? microsoft sqlserver microsoft visual studio
0
votes
0answers
7 views

SUB query execution strategy in Oracle on a table with huge number of tuple

We have a table with good amount of rows(150,000+) and each row has to be selected based on a SUB query on another table. The values return by SUB query is independent to the column in this table. So, ...
1
vote
0answers
23 views

How To Prevent Apps on macOS from Moving Themselves to the Applications Folder?

Some apps, like "Skype Meetings App" and "Join.me" surrepticiously copy themselves to your applications folder without asking or even so much as a notification. How can this be prevented? Isn't ...
0
votes
0answers
111 views

Command line to join .mp4 files with different frame width/height etc

I'd like to join multiple mp4 files into 1 file using VLC command line. (I'm using Windows 10, and VLC 3.0.4) I have tried the following command: "D:\VLC\vlc.exe" "1.mp4" "2.mp4" --sout "#gather:std{...
1
vote
2answers
51 views

How to join/merge 2 worksheet tables from time-series in Excel?

How do you join two datasets in excel from time-series, but the observations have been made at different times. How would you combine the observations in one table with the second? Example: table 1: ...
1
vote
1answer
61 views

selecting non matching records from full outer join

I have two tables tb1 ------- 1,ali 2,ana 3,kim 6,git 8,sen 9,pam tb2 ------- 2,joy 3,fin 4,roy 5,dina 9,tim output ------- 1,ali 2,joy 3,fin 4,roy 5,dina 6,git 8,sen 9,tim I need to join two ...
1
vote
2answers
306 views

Find multiple blank lines in Notepad++ and join the separated text lines

How to find multiple blank lines in Notepad++ and join the the separated text lines with a macro? Below is screenshot of the file, where I want a macro to find out this blank line and correct the SEE ...
1
vote
2answers
985 views

Merging Multiple files based on the common column

I have multiple files, each with two columns : For example : file1.txt ID Value1 1 40 2 30 3 70 file2.txt ID Value2 3 50 4 70 9 20 And so on, file1230.txt ID Value150 9 98 ...
0
votes
1answer
24 views

join files with variable column and line numbers and based on 1 field

Sorry in advance if it is too basic, I am a novice. I have two files (file1 and file2). I want to look in file1 column 6 and if it matches with an entry in column 1 of file 2, print the contents of ...
1
vote
3answers
7k views

Notepad++ Merge 10+ lines into 1 line

I'm trying to use Notepad++ to merge multiple lines into one. The problem I'm facing is when trying this code, I get this result: Date/Time: Sequence: Event: Category: Priority: Attention: Alert: ...
2
votes
1answer
448 views

Shell command 'Join' not working

I am joining two very simple sorted files but for some strange reason it is not working. f1.txt: f1 abc f2 mno f3 pqr f2.txt: abc a1 mno a2 pqr a3 Command: join -t '\t' f1.txt f2.txt -1 2 -2 1 &...
-1
votes
1answer
2k views

How to insert a video intro & outtro with ffmpeg

I have a video long time, i want to insert a video intro & outtro ? how can I do this? ffmpeg -i intro -i mainvideo -i outtro outputvideo
1
vote
1answer
158 views

cat files from pipe

I have to join files to one original file, which was split. There is a catalog, in which there are a lot of files,but no every is necessary. I have file with md5sum, which contain md5sum files I have ...
1
vote
1answer
2k views

Stack Ranges into 1 Column

If I had two columns by 4 rows: A1 B1 A2 B2 A3 B3 A4 B4 I would like the result A1 A2 A3 A4 B1 B2 B3 B4 I've used choose function to combine different ranges before ... but it doesn't seem to like ...
-2
votes
3answers
79 views

trying to join my computers in a more efficient way

i know there have several answers about how to link 2 computers together so they can share processing power. this seems to be way beyond what i need and i was hoping someone with more hardware and ...
-2
votes
1answer
93 views

Join some files in bash

I have a task. I have to join files A:B.dsv, B:D.dsv and N:A.dsv. Column are separated by ':'. And I have to join by relation N:D. And sort end file by D. A:B.dsv: R0X 7M3:48B56 L6R 5X3:08P68 E1W ...
0
votes
1answer
1k views

join - file is on sorted

I tried join two files, but I don't know why join doesn't listen to me. File i: 1 afjsadfjasdf 3 afdadsfa 4 afjdsakjfads 5 asdfadsfads 9 asfadsfads File k: 1 fdasdfadsfads 2 dfasjfadsjfas 3 ...
2
votes
0answers
260 views

Bash sort and join problems

I have to join two files. Firstly, I use commant sort and made two new sorted files. Next I use join, but it doesn't work. My script: sort -t ',' -r -k 4,4 file1.csv > sortf1.csv sort -t ',' -r -...
0
votes
2answers
139 views

Did I setup Active Directory on my server correctly? (re: Linux/OSX can't join domain)

I've just installed Active Directory on my Windows 2012 R2 server and my Windows 8/10 machines connect perfectly, but Linux and OSX can't seem to connect. The AD server's computer name is "DC01" and ...
0
votes
2answers
129 views

Sort on ID, then sort on date, then remove lines which have the older date?

I have a couple of tab delimited files. Each file is structured like so: ID Title Rating Date_Rated What I want to do is merge all these files into one, ...
0
votes
1answer
1k views

join 2 video file by command or code

i already use ffmpeg to join 2 files but there is some problem, second videos maybe have different dimension so get some error while converting : Command : ffmpeg -i introlq.mp4 -i lq1.mp4 -...
2
votes
1answer
117 views

Join files in the cloud

I have a Dropbox/One Drive/Google Drive account. I also have a very large file to be uploaded (12GB). My internet connectivity is limited, so I will not be able to upload the file in one go. Is there ...
2
votes
0answers
223 views

How to join 2 WAV files that overlap?

I have several WAV files that overlap a couple of seconds, concretely the first 6 or 7 seconds of one are the same as last of the previous. I'd like to join all of the chunks in just one file but ...
0
votes
1answer
1k views

Using SQL to join spreadsheets in excel

Based on the explanation here: How do I join two worksheets in Excel as I would in SQL? I tried to join two excel sheets from different files into the same sheet. However, I keep getting this error ...
-1
votes
1answer
49 views

Would shell command join cause out of memory?

I have two file to join. FILE 1: a A1 a A2 a A3 ... c C1 c C2 ... FILE 2: a feature1_of_a a feature2_of_a ... a featureN_of_a ... ... c feature1_of_c c feature2_of_c ... after join, i ...
30
votes
7answers
41k views

Join mp4 files in linux

I want to join two mp4 files to create a single one. The video streams are encoded in h264 and the audio in aac. I can not re-encode the videos to another format due to computational reasons. Also, I ...
2
votes
2answers
125 views

How to print separator for all fields in join utility?

For example: file a: Tom:black Lily:pink file b: Tom:big Kate:small And, the result: join -t: a1 a b Got: Tom:black:big Lily:pink But what I want is: Tom:black:big Lily::pink i.e. The ...
2
votes
2answers
1k views

Join with gzipped files

I want to use the command line join utility on two files. Unfortunately, they're gzipped. Because they're both gzipped, I can't use gzip -cd. Is there a slick way to do this without having to unzip ...
7
votes
6answers
2k views

Joining text files with 600M+ lines

I have two files, huge.txt and small.txt. huge.txt has around 600M rows and it's 14 GB. Each line has four space separated words (tokens) and finally another space separated column with a number. ...
5
votes
5answers
6k views

How to join MP3 files? [duplicate]

Motivation I'm looking for a program that allows me to join a lot of mp3 files (an audio book) to a single large mp3 file. My mp3 player is able to remember the position inside a track, but it takes ...