Hi guys
Could anyone advise me how to convert my rows into columns from a file
My file would be similar to this:
A11 A12 A13 A14 A15 ... A1n
A21 A22 A23
A31
A41
A51
...
Am1 Am2 Am3 Am4 Am5 ... Amn
The number of rows is not the same to the number of columns
Thanks in advance (2 Replies)
hi,
Apologies if this has been covered.
I have requirement where i have to convert a single column into multiple column.
My data will be like this -
2
3
4
5
6
Output required -
2 3 4 5 6 (1 Reply)
Hey all, I have a list in the format ;
variable length with spaces
more variable information
some more variable information
and I would like to transform that 'column' into rows ;
variable length with spaces more variable information some more variable information
Any... (8 Replies)
Hello,
I have a huge tab delimited file with around 40,000 columns and 900 rows I want to convert columns to a row.
INPUT file look like this.
the first line is a headed of a file.
ID marker1 marker2 marker3 marker4
b1 A G A C ... (5 Replies)
Hi Gurus,
How to convert rows in to columns using linux shell scripting
Input is like (sample.txt)
ABC
DEF
GHI
JKL
MNO
PQR
STU
VWX
YZA
BCD
output should be (sampleoutput.csv)
ABC,DEF,GHI,JKL,MNO
PQR,STU,VWX,YZA,BCD (2 Replies)
Hi Everyone,
Could someone shed some lights on how to convert the records in rows form into column basis.
172.29.59.12
IBM,8255-E8B
102691P
8
65536 MB
6100-04-11-1140
172.29.59.15
IBM,8255-E8B
102698P
4
45056 MB
6100-04-11-1140
IP SYS MODEL ... (6 Replies)
hi folks,
I have a sample data like what is shown below:
1,ID=1000
1,Org=CedarparkHospital
1,cn=john
1,sn=doe
1,uid=User001
2,uid=User002
2,ID=2000
2,cn=steve
2,sn=jobs
2,Org=Providence
I would like to convert it into the below format:
1,1000,CedarparkHospital,john,doe,User001... (11 Replies)
Discussion started by: vskr72
11 Replies
LEARN ABOUT SUSE
create_foreign_data_wrapper
CREATE FOREIGN DATA WRAPPER(7) SQL Commands CREATE FOREIGN DATA WRAPPER(7)NAME
CREATE FOREIGN DATA WRAPPER - define a new foreign-data wrapper
SYNOPSIS
CREATE FOREIGN DATA WRAPPER name
[ VALIDATOR valfunction | NO VALIDATOR ]
[ OPTIONS ( option 'value' [, ... ] ) ]
DESCRIPTION
CREATE FOREIGN DATA WRAPPER creates a new foreign-data wrapper. The user who defines a foreign-data wrapper becomes its owner.
The foreign-data wrapper name must be unique within the database.
Only superusers can create foreign-data wrappers.
PARAMETERS
name The name of the foreign-data wrapper to be created.
VALIDATOR valfunction
valfunction is the name of a previously registered function that will be called to check the generic options given to the foreign-
data wrapper, as well as to foreign servers and user mappings using the foreign-data wrapper. If no validator function or NO VALIDA-
TOR is specified, then options will not be checked at creation time. (Foreign-data wrappers will possibly ignore or reject invalid
option specifications at run time, depending on the implementation.) The validator function must take two arguments: one of type
text[], which will contain the array of options as stored in the system catalogs, and one of type oid, which will be the OID of the
system catalog containing the options. The return type is ignored; the function should indicate invalid options using the ereport()
function.
OPTIONS ( option 'value' [, ... ] )
This clause specifies options for the new foreign-data wrapper. The allowed option names and values are specific to each foreign
data wrapper and are validated using the foreign-data wrapper library. Option names must be unique.
NOTES
At the moment, the foreign-data wrapper functionality is very rudimentary. The purpose of foreign-data wrappers, foreign servers, and user
mappings is to store this information in a standard way so that it can be queried by interested applications. One such application is
dblink; see in the documentation. The functionality to actually query external data through a foreign-data wrapper library does not exist
yet.
There is currently one foreign-data wrapper validator function provided: postgresql_fdw_validator, which accepts options corresponding to
libpq connection parameters.
EXAMPLES
Create a foreign-data wrapper dummy:
CREATE FOREIGN DATA WRAPPER dummy;
Create a foreign-data wrapper postgresql with validator function postgresql_fdw_validator:
CREATE FOREIGN DATA WRAPPER postgresql VALIDATOR postgresql_fdw_validator;
Create a foreign-data wrapper mywrapper with some options:
CREATE FOREIGN DATA WRAPPER mywrapper
OPTIONS (debug 'true');
COMPATIBILITY
CREATE FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED), with the exception that the VALIDATOR clause is an extension and the
clauses LIBRARY and LANGUAGE are not yet implemented in PostgreSQL.
Note, however, that the SQL/MED functionality as a whole is not yet conforming.
SEE ALSO
ALTER FOREIGN DATA WRAPPER [alter_foreign_data_wrapper(7)], DROP FOREIGN DATA WRAPPER [drop_foreign_data_wrapper(7)], CREATE SERVER [cre-
ate_server(7)], CREATE USER MAPPING [create_user_mapping(7)]
SQL - Language Statements 2010-05-14 CREATE FOREIGN DATA WRAPPER(7)