Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

An error occurs when importing data(.txt file). Is there a way to reflect?

solbums48271185
Level 1
Level 1

hello!

An error occurs when importing data(.txt file). Is there a way to reflect?

# The screen order below is the data import order.

1396746_pastedImage_0.png

1396747_pastedImage_1.png

1396766_pastedImage_2.png

Thank you.

5 Replies
davidk46719882
Level 3
Level 3

You need to define a reconciliation key between your file and destination schema. see an example below

1398843_pastedImage_0.png

solbums48271185
Level 1
Level 1

Hi,

Even after defining an arbitration key between the file and the target schema

It will fail.

Is there another way?

1401150_pastedImage_0.png

florentlb
Level 10
Level 10

Hi,

Can you share a screenshot of your workflow? Can you try using an enrichment activity between your file loading and data update activities, to define the reconciliation before the update data activity (simply define the Reconciliation tab of the enrichment as described here: Targeting activities​) ?

Florent

wkt85768776
Level 3
Level 3

You should change the operation type to insert, u shouldnt have it in InsertOrUpdate.

1425165_pastedImage_1.png