topic Re: Two tables with two dates in App Development

Two tables with two dates

vbravomo — Wed, 20 Jun 2018 10:27:23 GMT

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

Re: Two tables with two dates

PrashantSangle — Wed, 20 Jun 2018 10:41:55 GMT

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

Load date1 as date,

Users,

...

from table1

concatenate

Load date2 as date,

number of calls,

...

from table2

Regards,

Re: Two tables with two dates

vbravomo — Wed, 20 Jun 2018 12:11:58 GMT

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"