have a calculated field in each of the data source and name it as a constant value of Source 1 and source 2 respectively. then use these source identifiers to do the calculation. hope this helps
Thanks for the response Ojoswi.
I still need to compare b/w the CreatedDate in the 2 sources. I can't do that with the constant.
I don't think you can do a full outer join with blending.
Is join or union out of question?
I think you made a mistake in your documentation here:
First Data Source 3 ( 345, 444 )
Second Data Source 2 ( 123, 234, 987 )
I can't Join, since the information is coming from 2 different sources.
First Data Source 3 ( 123, 234, 444 )
Second Data Source 2 ( 345, 987 )
I am sorry to say that I don't know any other solution than adding them to the same data source, such as text files, Excel sheets, or even in a database.
You might like to up-vote OUTER JOIN. If implemented, it would solve your issue.
That said, I think
are more realistic to see in production, and therefore more important to up-vote.
But you can up-vote them all