ETL01InventoryBalances SUCCESS
ETL02EvavivsStagingSalesOrders SUCCESS
ETL03StagevsODSSalesOrder SUCCESS
ETL04EvavivsSalesOrderHeader History SUCCESS
ETL05EvavivsSalesOrderLine History SUCCESS
ETL07EvavivsStageRAs SUCCESS
ETL08StagevsODSRAs SUCCESS
ETL09StagetoODSIdentifierAttachments SUCCESS
ETL10EvavitoStageWTs SUCCESS
ETL11StagevsODSShippingOrder SUCCESS
ETL12StagevsODSShippingOrder Line SUCCESS
ETL13StagevsODSShipments SUCCESS
ETL14StagevsODSShipmentLines SUCCESS
ETL15StagevsODSPurchaseOrder SUCCESS
ETL16StagevsODSPurchaseOrder Lines SUCCESS
ETL17StagevsODSInventoryTransactions SUCCESS
ETL18StagevsODSOrders SUCCESS
ETL19StagevsODSOrderLines SUCCESS
ETL20StagevsODSShippingOrder SUCCESS
ETL21StagevsODSShippingOrder Lines SUCCESS
ETL22ODS Duplicate Shipments SUCCESS
ETL23Evavi vs Stage Sales Order Lines SUCCESS
ETL24Evavi vs ODS Sales Order Lines SUCCESS
ETL33Source to ODS Identifier AttachmentSUCCESS
SND01Serialized ODS Shipments vs SND SUCCESS
SND02SND vs Serialized ODS Shipments SUCCESS
SND03WMS DMR- ERR records in ViawareSUCCESS
SND04Evavi DMR - ERR records SUCCESS
VIA01Viaware Cost Status SUCCESS
Here, I need to sort them and remove duplicate records (If any) and extract them to a separate file which will further be inserted into a table where just 2 columns and this file value will populate the primary key column of that table. Before going to the table, the extract file should contain only unique records in it.
Moderator's Comments:
Please use CODE tags as required by forum rules when displaying sample input, sample output, and code segments.
---------- Post updated at 03:22 PM ---------- Previous update was at 03:06 PM ----------
Lets assume that I need to compare the fields that are unique in first 150 bytes of each line in the file.
sort -u will give the unique records for the entire file. But I want this uniqueness to be checked around 150 bytes of the line in the file.
Last edited by Don Cragun; 02-27-2017 at 04:28 PM..
Reason: Add CODE tags.
Hi,
I need some help in knowing how I can append tabs at the end of each line...
The data looks something like this:
field1, field2, field3, field4
1 2
3 4 5
I have values in field1 and field 2 in the first row and I would like to append tab on field3 and field4 for the first row..and in... (6 Replies)
Greetings,
I would like to extract records from a fixed width text file that have unique field elements.
Data is structured like this:
John A Smith NY
Mary C Jones WA
Adam J Clark PA
Mary Jones WA
Fieldname / start-end position
Firstname 1-10... (8 Replies)
I have a situation where I am reading a text file line-by-line. Those lines of data contain comma separated fields of data. However, each line can vary in the number of fields it can contain. What I need to do is parse apart each line and write each field of data found (left to right) into a file.... (7 Replies)
Hi,
I have a file like this:
Some_String_Here 123 123 123 321 321 321 3432 3221 557 886 321 321
I would like to find only the unique values in the files and get the following output:
Some_String_Here 123 321 3432 3221 557 886
I am trying to get this done using awk. Can someone please... (5 Replies)
Hi all,
I have got a problem while comparing 2 text files and the result should contains the unique values(Non repeatable).
For eg:
file1.txt
1
2
3
4
file2.txt
2
3
So after comaping the above 2 files I should get only 1 and 4 as the output. Pls help me out. (7 Replies)
My data is something like as shown below. Out of this i want the details of alarms (ex: 1947147711,1947147081......) and the fields( ex :sw=tacmwafabb9:shelf=1:slot=5-2:pport=2)
Once i have these details separated, i want the count of these excluding the duplicates. What is the best possible way... (7 Replies)
I have high values (such as ÿÿÿÿ) in a text file contained in an Unix AIX server. I need to identify all the records
which are having these high values and also get the position/column number in the record structure if possible. Is there
any Unix command by which this can be done to :
1.... (5 Replies)
Good morning all,
I have a problem that is one step beyond a standard awk compare.
I would like to compare three files which have several thousand records against a fourth file. All of them have a value in each row that is identical, and one value in each of those rows which may be duplicated... (1 Reply)
Hi would like to ask you guys any advise regarding my problem
I have this kind of data
file.txt
111111111,20
111111111,50
222222222,70
333333333,40
444444444,10
444444444,20
I need to get this
file1.txt
111111111,70
222222222,70
333333333,40
444444444,30
using this code I can... (6 Replies)
datafile:
2017-03-24 10:26:22.098566|5|'No Route for Sndr:RETEK RMS 00040 /ZZ Appl:PF Func:PD Txn:832 Group Cntr:None ISA CntlNr:None Ver:003050 '|'2'|'PFI'|'-'|'EAI_ED_DeleteAll'|'EAI_ED'|NULL|NULL|NULL|139050594|ActivityLog|
2017-03-27 02:50:02.028706|5|'No Route for... (7 Replies)
Discussion started by: SkySmart
7 Replies
LEARN ABOUT CENTOS
dblink_get_pkey
DBLINK_GET_PKEY(3) PostgreSQL 9.2.7 Documentation DBLINK_GET_PKEY(3)NAME
dblink_get_pkey - returns the positions and field names of a relation's primary key fields
SYNOPSIS
dblink_get_pkey(text relname) returns setof dblink_pkey_results
DESCRIPTION
dblink_get_pkey provides information about the primary key of a relation in the local database. This is sometimes useful in generating
queries to be sent to remote databases.
ARGUMENTS
relname
Name of a local relation, for example foo or myschema.mytab. Include double quotes if the name is mixed-case or contains special
characters, for example "FooBar"; without quotes, the string will be folded to lower case.
RETURN VALUE
Returns one row for each primary key field, or no rows if the relation has no primary key. The result row type is defined as
CREATE TYPE dblink_pkey_results AS (position int, colname text);
The position column simply runs from 1 to N; it is the number of the field within the primary key, not the number within the table's
columns.
EXAMPLES
CREATE TABLE foobar (
f1 int,
f2 int,
f3 int,
PRIMARY KEY (f1, f2, f3)
);
CREATE TABLE
SELECT * FROM dblink_get_pkey('foobar');
position | colname
----------+---------
1 | f1
2 | f2
3 | f3
(3 rows)
PostgreSQL 9.2.7 2014-02-17 DBLINK_GET_PKEY(3)