topic Re: Reading two records having a single index in App Development

Reading two records having a single index

odaher123 — Sat, 31 Dec 2016 17:34:32 GMT

Hello everyone,

The concatenation of a file A and a file B gives the following:

Customer_Code Customer_Name

123 Client_ABC

123 Client_EFG

I wish to keep the first one: (Client_ABC)

How to do ?

Thank you

Re: Reading two records having a single index

vinieme12 — Sun, 01 Jan 2017 06:33:09 GMT

So you only want to load records from File B that do not exist in File A ?

Try as below

Load

Customer_Code,

Customer_Name

From FileA;

concatenate

Load

Customer_Code,

Customer_Name

From FileB

WHERE NOT EXISTS(Customer_Code);

Re: Reading two records having a single index

odaher123 — Mon, 02 Jan 2017 00:11:58 GMT

Thank you very much for your help, however you must have identical field names in both tables.

Re: Reading two records having a single index

vinieme12 — Mon, 02 Jan 2017 07:09:05 GMT

Can you confirm if my assumption is correct

So you only want to load records from File B that do not exist in File A ?

If not, then on what basis should we exclude a row.

Can you post your script?

Re: Reading two records having a single index

odaher123 — Tue, 03 Jan 2017 20:01:30 GMT

// The 1st File

[Clients_S]:

LOAD

[Code Client] as Code_Client,

Client

FROM

(qvd);

Store Clients_S into ;

Drop table Clients_S;

// The 2nd File

Clients_Sellsy:

LOAD

[Code compte auxiliaire] as Code_Client,

[Client]

FROM

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Store Clients_Sellsy into ;

Drop table Clients_Sellsy;

Clients:

Load *

From

(qvd);

Load *

From

(qvd)

WHERE NOT EXISTS ([Code_Client]);

Store Clients into ;

Re: Reading two records having a single index

vinieme12 — Wed, 04 Jan 2017 08:39:26 GMT

Not Necessarily

For your Script

// The 1st File
[Clients_S]:
LOAD
[Code Client] as Code_Client,
Client
FROM (qvd);

// The 2nd File
Clients_Sellsy:
LOAD
[Code compte auxiliaire] as Code_Client,
[Client]
FROM
(txt, codepage is 1252, embedded labels, delimiter is ';', msq)
Where Not Exists (Code_Client, [Code compte auxiliaire]);

try below example

Load * inline [
Customer_Code,Customer_Name
123,ABC
546,XYZ
];
concatenate
Load CCode as Customer_Code,Customer_Name inline [
CCode,Customer_Name
123,XYZ
789,CVB
]
WHERE NOT EXISTS(Customer_Code,CCode);