Join Tabular

[#1]

Dear all,

Is it possible to make relationship between two tabular data..In one tabular i have sales qty and sales value.. in another tabular i have article name and article category.. Now i want to make a relationship between two tabular and finally data will be show one tabular..For your better understanding please see below attachment.

[nagaiank · Accepted solution]

For your sample data, no special efforts needed. If you load the data in two tables, one having fieldnames Article, [Sale Qty], and [Sale Value] and the other table having the fieldnames Article, Stock and Categorry, the tables are linked automatically. You may create a Table Box with all the fieve fields to see the data in one table.

[#3]

Dear Nagaink,

Thanks for your prompt reply.

[its_anandrjs]

Hi,

In this two tables there is a common field names Article so by this this two table connect to each other and by this you can get the records of this two table into single table.

And you can also join this table or will be leave the association way

1. First way is

Load Article, [Sale Qty], and [Sale Value] From Source;

Load Article, Stock and Category From Source;

2. Second way of doing same is

Load Article, [Sale Qty], and [Sale Value] From Source;

Join

Load Article, Stock and Category From Source;

Regrads

Anand