Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

combining 2 table

Trying to combine 2 table, both got the right order , so just need to combine line per line:

23-04-2018 11-23-04.png

Thanks,

Raphael

MyNames:

LOAD * INLINE [

    Name, Date

    Jim, 01/01/2010

    Dan, 01/01/2010

    Laura, 01/01/2010

    Jim, 20/01/2010

    Dan, 20/01/2010

    Laura, 20/01/2010

    Jim, 25/01/2010

    Dan, 25/01/2010

    Laura, 25/01/2010

];



Concatenate (MyNames)


MyGrades:

LOAD * INLINE [

    Name, Grade

    Jim, 10

    Dan, 20

    Laura, 30

    Jim, 100

    Dan, 200

    Laura, 300

    Jim, 1000

    Dan, 1000

    Laura, 1000

];

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

Try with:

MyNames:

LOAD

  Name,

  Date,

  RowNo() as id

INLINE [

    Name, Date

    Jim, 01/01/2010

    Dan, 01/01/2010

    Laura, 01/01/2010

    Jim, 20/01/2010

    Dan, 20/01/2010

    Laura, 20/01/2010

    Jim, 25/01/2010

    Dan, 25/01/2010

    Laura, 25/01/2010

];

Left Join

LOAD

    Name,

    Grade,

    RowNo() as id

INLINE [

    Name, Grade

    Jim, 10

    Dan, 20

    Laura, 30

    Jim, 100

    Dan, 200

    Laura, 300

    Jim, 1000

    Dan, 1000

    Laura, 1000

];

Saludos.

View solution in original post

3 Replies
Highlighted
Partner
Partner

Hi,

Try with:

MyNames:

LOAD

  Name,

  Date,

  RowNo() as id

INLINE [

    Name, Date

    Jim, 01/01/2010

    Dan, 01/01/2010

    Laura, 01/01/2010

    Jim, 20/01/2010

    Dan, 20/01/2010

    Laura, 20/01/2010

    Jim, 25/01/2010

    Dan, 25/01/2010

    Laura, 25/01/2010

];

Left Join

LOAD

    Name,

    Grade,

    RowNo() as id

INLINE [

    Name, Grade

    Jim, 10

    Dan, 20

    Laura, 30

    Jim, 100

    Dan, 200

    Laura, 300

    Jim, 1000

    Dan, 1000

    Laura, 1000

];

Saludos.

View solution in original post

Highlighted
Creator III
Creator III

Thank you!

Highlighted
Master
Master

May be this?