joning of two table in a single table inside the script

[#1]

Hi,

I have two tables and now i need to combine the columns of these two into a third table inside the script.

I need a third table with  all the values in other tables.

I am sharing the app

[ecolomer]

Is this you need?

[#3]

Hi ,

try like this .

Sp:

LOAD * INLINE [

    Sales, Person

    1000, Nain

    200, yoni

    3000, Hui

];

join

Dept:

LOAD * INLINE [

    Sales_ID, Sales_Dept

    S01, Acc

    S02, Mark

    S09, Dirct

];

Thanks !!

[#4]

Hi,

I dont want them in UI.

need them inside the script like this in a single table

SalesDetails:

Sales	Person	Sales_Id	Sales_Dept
1000	Nain	S01	Acc
200	Yoni	S02	Mark

or like this

SalesDetails:

Sales

Person

Sales_ID

Sales_Dept

[ecolomer]

See this

[#6]

Sp:

LOAD * INLINE [

    Sales, Person

    1000, Nain

    200, yoni

    3000, Hui

];

join

Dept:

LOAD * INLINE [

    Sales_ID, Sales_Dept

    S01, Acc

    S02, Mark

    S09, Dirct

];

Final :

NOconcatenation

Load * resident Sp ;

drop table SP;