Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

joning of two table in a single table inside the script

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

5 Replies
ecolomer
Master II
Master II

Is this you need?

Not applicable
Author

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 !!

Not applicable
Author

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
Master II
Master II

See this

Not applicable
Author

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;