Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
fvelascog72
Partner - Specialist
Partner - Specialist

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
fvelascog72
Partner - Specialist
Partner - Specialist

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.

Anonymous
Not applicable
Author

Thank you!

shiveshsingh
Master
Master

May be this?