Concatenate

[#1]

I have the following tables:

Entry No_	Item No_	Quantity	Entry Type	Document No_
3248633	224964	-100	5	RC-32538

Table2:

Entry No_	Item No_	Quantity	Entry Type	Document No_
32486300	1	-9	5	RC-32538
32486319	2	-9	5	RC-32538
19	6	-9	5	RC-32539
38	7	-9	5	RC-32539

I want to concatenate Table 2 with Table 1.

but where document No.s are not the same.

Since RC-32538 already appeared in the first table, only the ;last two records should be concatenated with the first table.

The result table should be as follows:

Entry No_	Item No_	Quantity	Entry Type	Document No_
3248633	224964	-100	5	RC-32538
19	6	-9	5	RC-32539
38	7	-9	5	RC-32539

Can anyone help me with a possible solution.

[#2]

Hey Kartik,

Use attached QVW hope it might help.

Regards,

Nitesh

[anbu1984]

Try this

RC:

LOAD [Entry No_],

    [Item No_],

    Quantity,

    [Entry Type],

    [Document No_] As Doc

FROM

RC.xlsx

(ooxml, embedded labels, table is Sheet1);

RC1:

Load [Entry No_],[Item No_],Quantity,[Entry Type],[Document No_] As Doc;

LOAD [Entry No_],

    [Item No_],

    Quantity,

    [Entry Type],

    [Document No_]

FROM

RC.xlsx

(ooxml, embedded labels, table is Sheet2)

where not exists (Doc,[Document No_]);

You will get two rows with all fields as Nulls. This is because you have empty rows in Sheet1. You have to delete those rows.

[#4]

Hi,

Try this script.

Table1:

LOAD

[Entry No_],

[Item No_],

Quantity,

[Entry Type],

[Document No_]

FROM  (Source Path);

Concatenate (Table1)

LOAD

[Entry No_],

[Item No_],

Quantity,

[Entry Type],

[Document No_]

FROM (Source Path)

Where [Document No_] <> RC-32538;

[hariprasadqv]

Hi,

use where condetion along with not exists.