Skip to main content
Unix & Linux

Return to Question

add awk tag
Link
thanasisp
thanasisp
  • 8.5k
  • 2
  • 29
  • 40
added 43 characters in body; edited tags
Source Link
thanasisp
thanasisp
  • 8.5k
  • 2
  • 29
  • 40

File_1

Group Country Lang

IT USA ENG

Group   Country Lang
IT      USA     ENG

File_2

EMPID STOREID

1001 1400

1002 1401

1003 1401

EMPID   STOREID
1001    1400
1002    1401
1003    1401

If iI use paste -d'\t' File_1 File_2, i an getting

Group^ICountry^ILang^IEMPID^ISTOREID$

paste -d'\t' File_1 File_2

IT^IUSA^IENG^I1001^I1400$I get

^I1002^I1401$
^I1003^I1401$

Group^ICountry^ILang^IEMPID^ISTOREID$
IT^IUSA^IENG^I1001^I1400$
^I1002^I1401$   
^I1003^I1401$

While iI am trying to get something like this

Group Country Lang EMPID STOREID

IT USA ENG 1001 1400

IT USA ENG 1002 1401

IT USA ENG 1003 1401

Group   Country Lang    EMPID   STOREID
IT  USA ENG     1001    1400
IT  USA ENG     1002    1401
IT  USA ENG     1003    1401

Please suggest

File_1

Group Country Lang

IT USA ENG

File_2

EMPID STOREID

1001 1400

1002 1401

1003 1401

If i use paste -d'\t' File_1 File_2, i an getting

Group^ICountry^ILang^IEMPID^ISTOREID$

IT^IUSA^IENG^I1001^I1400$

^I1002^I1401$
^I1003^I1401$

While i am trying to get something like this

Group Country Lang EMPID STOREID

IT USA ENG 1001 1400

IT USA ENG 1002 1401

IT USA ENG 1003 1401

Please suggest

File_1

Group   Country Lang
IT      USA     ENG

File_2

EMPID   STOREID
1001    1400
1002    1401
1003    1401

If I use

paste -d'\t' File_1 File_2

I get

Group^ICountry^ILang^IEMPID^ISTOREID$
IT^IUSA^IENG^I1001^I1400$
^I1002^I1401$   
^I1003^I1401$

While I am trying to get something like this

Group   Country Lang    EMPID   STOREID
IT  USA ENG     1001    1400
IT  USA ENG     1002    1401
IT  USA ENG     1003    1401

Please suggest

Source Link
itsavy
itsavy
  • 103
  • 2

Linux one row from first file combine into multiple rows in second file, transpose denormalize

File_1

Group Country Lang

IT USA ENG

File_2

EMPID STOREID

1001 1400

1002 1401

1003 1401

If i use paste -d'\t' File_1 File_2, i an getting

Group^ICountry^ILang^IEMPID^ISTOREID$

IT^IUSA^IENG^I1001^I1400$

^I1002^I1401$
^I1003^I1401$

While i am trying to get something like this

Group Country Lang EMPID STOREID

IT USA ENG 1001 1400

IT USA ENG 1002 1401

IT USA ENG 1003 1401

Please suggest