tMap Left Outer Join is not working for two different data sources data(MySql and MongoDB)

[Anonymous]

Hello All,

I was trying to collect data from different sources and create a model.

So, In process of doing that, I have employee related data in MySql and Employee SwipeIn and SwipeOut data in MongoDB.

I did succeeded by connecting and getting data from both sources and i have used tAggregate to aggregate swipe data.

My Workflow looks like below image

In tMap_2 i do have the columns of Date, EmpID.

the output columns of taggregaterow are EmpID, Date, Time, Type

Now, By using tMap3, i am trying to join these two tables columns based on EmpID and Date as left outer join.

Before that, to Create Connections between tMap_2 --> tMap3 and tAggregateRow_1 --> tMap_3,

I was able to create connection between  tMap_2 --> tMap3 without any issue.

But when i try to create connection between tAggregateRow_1 --> tMap_3 i couldnt. it is not allowing me to create. then i have to deactivate connection between tMap_2 --> tMap3 and then i created connection between tAggregateRow_1 --> tMap_3 and then i activated connection between tMap_2 --> tMap3.

After all these, i did used left outer join as below image to join these columns.

Output:-

As you see in above output image i am unable to get those two columns which i want.

I did tried using tJoin in place of tMap_3 but still i am getting the same result.

I guess it is because of the activity that i mentioned in bold if i am not wrong.

Can anyone please guide me where i was going wrong.

Thank in advance.

Mohan V.

[Anonymous]

@rhall  Oh My.......

I didn't even think about doing it mannn...

This was the straight point that causing all these things.

Thank god.

At last.

i am so thankful you buddy.

the dates that i am getting from mongodb are in dd-mm-yyyyy hh:mm:ss (01-04-2019 05:30:00 AM) and the dates that i am getting from Mysql are dd-mm-yyyyy hh:mm:ss (01-04-2019 12:00:00 AM).

And because of this, the join is not working.

[Anonymous]

These things catch the best of us out 🙂