Concatenate two tables with focus on WeekDay

[Anonymous]

Hello,

I'd like to concatenate these two tables.

But the problem is that WeekDay field from the first isn't equals to WeekDay from the second.

How to concatenate in this case and apply a "date" format to the crosstable's field? (I can't change WeekDay from the first table to text)

Example:

Table1:

load ID, Sales,

Store,

WeekDay(Date) as WeekDay,  // Mon, Tue, etc.

from source_1;

CrossTable('WeekDay', 'Sales', 2)

Table2:

load ID, Store

Monday as Mon,

Tuesday as Tue,

Wednesday as Wed

.. etc.

from source_2;

With best regards,

Evgeniy Sharahov

[Anonymous]

Thank you very much, Sunny Talwar!

Probably, correct this one:)

Dual(WeekDay, (Match(WeekDay,  'Mon', 'Tue', 'Wed', 'Thur', 'Fri', 'Sat', 'Sun') - 1)) as Day,