Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
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"