Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Is this you need?
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 !!
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 |
See 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
];
Final :
NOconcatenation
Load * resident Sp ;
drop table SP;