Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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.
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.
Thank you!
May be this?