New Project

[#1]

Hi everybody!

Today i would ask if you could help me.

I'm starting a project, maybe a bit difficult for me, but not for u! (i will be really greatful if someone could give me some advices)

The project is defined as follows:

I have n firms that could be client or supplier (flag C or S) of n other firms(indicates by Code). I should create all the possible combinations between them.

Key/legend:

a(firm) -->(corresponds) 20(code as supplier);

b --> 21;

c --> 10;

d --> 11;

Table for The Seller

Firm	Client/supplier	Code	Materials	Assets	Method
a	c	10	00000	11111	P
b	c	11	22222	45454	S

Table for The Acquirer (indicates the invert selection: i mean, if Firm a has a client identificated with 10, firm 10(which has an alfanumeric field associated)  should appears in the follows table:

Firm	Client/supplier	Code	Materials	Assets	Method
c	s	20	00000	11111	P
d	s	21	22222	45454	s

Thanks so much in advance. If it is not clear, dont' hesitate to ask informations!

[#2]

Hi Singh,

i followed your advices but my problem is to write the code.

I don't know how to join the two tables:

i wrote the follows code:

Directory

Tab_ Supplier

'S' as Supplier,

Supplier_Code,

Supplier_Name,

Supplier_Abbrevation,

Client

from supplier.xls

Directory

Tab_ Client

'C' as Client,

Client_Code,

Client_Name,

Client_Abbrevation,

Supplier

from Client.xls

the problem in now. What i have to write to join the tables?

Thanks for your first answer, and thanks in advance for you attention.

Domenico

[#3]

HI

ex: u have table1 and table 2 

table1(load table1 here)

join

table2(load table2)

[#4]

Hi Alkesh,

Thanks in advance for your answer.

If i write the code u shown i received the error that fields must be unique.

[#5]

thanks for your answer.

What i have to write in order to obtain the results above illustrated?

thanks in advance

[Anonymous]

Hi Use the below code

This might help u if u didn't get the exact solution post the sample data .....

Tab1:

Tab_ Supplier

'S' as Supplier,

Supplier_Code as CODE_TEST,

Supplier_Name,

Supplier_Abbrevation,

Client

from supplier.xls

Left Join(Tab1)

Tab_ Client

'C' as Client,

Client_Code as  CODE_TEST,

Client_Name,

Client_Abbrevation,

Supplier

from Client.xls

[#7]

I have this two tables. One about the supplier and the other one of Client.

(the output should be like the table Output (into the sheet supplier)