combining 2 table

[Anonymous]

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

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

];

[fvelascog72 · Accepted solution]

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]

Thank you!

[shiveshsingh]

May be this?