Question

Write a C# or C++ code to do the following:

-Ask user for name of file1 and file2

(These files should contains numbers representing rows and cols in a table- see below)

-Read the content of the files into 2 arrays or something

-Ask user which column to compare in array1 and which col in array2 to join the two tables.

Loop through arrays and if the element in specified col of array1 matches the element in specified col of arrar2, then output the entire row from both arrays (similar to join of tables).

example of file1:

1 2 3

1 2 3

1 2 3

file2

1 2 7 8

1 2 0 3

1 5 7 2

9 6 3 1

2 3 4 1

the information of rows/ cols doesn't have to be present in the files but it can be.

Answer 1

C++ CODE:

#include<iostream>
#include<fstream>
using namespace std;
int main()
{
cout<<"JOIN ARRAYS"<<endl;
ifstream fin;
cout<<"Enter name of file 1:";
string file1;
cin>>file1;
fin.open(file1.c_str());
int m1=0;
string line;
while(fin)
{
getline(fin,line);
m1++;
}
m1--;
fin.close();
fin.open(file1.c_str());
int r;
int n1=0;
while(fin)
{
fin>>r;
n1++;
}
n1--;
n1=n1/m1;
int** arr1 = new int*[m1];
for(int i=0;i<m1; i++)
arr1[i]=new int[n1];
fin.close();
fin.open(file1.c_str());
for(int i=0;i<m1;i++)
{
for(int j=0;j<n1;j++)
{
int val;
fin>>val;
arr1[i][j]=val;
}
}
fin.close();
cout<<"Enter name of file 2:";
string file2;
cin>>file2;
fin.open(file2.c_str());
int m2=0;
while(fin)
{
getline(fin,line);
m2++;
}
m2--;
fin.close();
fin.open(file2.c_str());
int n2=0;
while(fin)
{
fin>>r;
n2++;
}
n2--;
n2=n2/m2;
int** arr2 = new int*[m2];
for(int i=0;i<m2; i++)
arr2[i]=new int[n2];
fin.close();
fin.open(file2.c_str());
for(int i=0;i<m2;i++)
{
for(int j=0;j<n2;j++)
{
int val;
fin>>val;
arr2[i][j]=val;
}
}
fin.close();
cout<<"Enter the column no. for comparison in first matrix(starting from 0): ";
int c1;
cin>>c1;
cout<<"Enter the column no. for comparison in second matrix(starting from 0): ";
int c2;
cin>>c2;
for(int i=0;i<m1;i++)
{
for(int j=0;j<m2;j++)
{
if(arr1[i][c1]==arr2[j][c2])
{
for(int k=0;k<n1;k++)
cout<<arr1[i][k]<<" ";
for(int k=0;k<n2;k++)
cout<<arr2[j][k]<<" ";
cout<<endl;
}
}
}
return 0;
}

Input file:

file01.txt

file02.txt

Output: