Home > Forum > Data sources > Data migration

Data migration
0

Hi, I'm going through data migration process via sharepoint lists and the protocol that I want to achieve it with is by using cyclical actions. I've created an automation that is runing subworkflow(sql) and there is a problem with mapping. Data source has exact values that I need, and I'm using them as intended but the problem is I'm getting data rows I don't want and even then those queried fields are still not applied to created instances after running the action, so that leads me to believing that something is wrong. In the end, instances created are empty and those 2 fields I only used for testing purposes are still not applied.

MVP

Hi,
Can you show a preview of this query with the fields replaced? (You should have columns matching the column names in WFElements, e.g., WFD_AttText1 or WFD_Attint1)

Standord_id - looks ok.
Position - you need to provide "Database field name" without the "- Name."

I can't check right now, but if I remember correctly, these fields should be visible and editable in the attribute matrix at the first step.