Two tables with two dates

[vbravomo]

Hi everyone,

I need you a lot.

I have two tables: the first one has the date, users, and more; the second one has the date, number of calls and more. I need to create a graphic ordering by date, with the count(USERS) and the number of calls.

I've tried with outer join and ApplyMap, but it doesn't work or maybe I didn't do it well.

Thank you so much

[PrashantSangle]

concat both the table keep alise both date as same name..

like

Load date1 as date,

         Users,

      ...

from table1

concatenate

Load date2 as date,

         number of calls,

      ...

from table2

Regards,

[vbravomo]

I've tried this:

Load Llam_atendidas_SS, FECHA_SS AS fecha FROM Llamadas;

concatenate

Load USER,[Started On] as fecha FROM [ACTIVIDAD POR MES];

but it doesn't work: "No qualified path for file"