gistfile1.txt

USE "Server=localhost;Database=KardaNorm;Trusted_Connection=True;" as norm;
USE "Server=localhost;Database=KardaManual;Trusted_Connection=True;" as manual;

SOURCE s FROM manual.vbv.VBV_MATT_STYRKORT as matt
	CHOOSE Namn, Falt
	LOOKUP Namn as AggEnhetNamn, Id as AggId FROM INNER JOIN manual.vbv.AggregeringsEnhet as aggenhet ON aggenhet.AggregeringsEnhetID = matt.AggregeringsEnhetID
;

TARGET norm.vbv.Matt t
	IDENTIFY USING s.Falt = t.Falt
	MAP
	(
		Namn <- Namn,
		AggregeringsTyp <- AggEnhetNamn
	)
	ALLOW: INSERT, UPDATE
;