Table matching

Dynamics 365 for Finance and Operations/AX Developer Forum
#1

Hi,

I’m new AX 2009 programmer. My first project is to match two table contents and then display the mis-matched data. Would someone help me start on this? Thanks

In two tables are not in database and I needs to be imported. Any idea on how to do that? tables are in .csv file

#2

use notexist join for that two tables…

#3

Hi,

Using NoExists Join it will return Mis-Matched Records

#4

Thanks guys I’ll try that. One problem though is the two tables have different time zone. How do I adjust the time?

#5

Would any of you give me a sample code on how to do the table data matching.

#6

Hi,

Hope you found what you were looking for. Just in case, SQL examples can be found here - http://msdn.microsoft.com/en-us/library/aa656402.aspx