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?

Avatar

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.

2 Replies

Avatar

Level 3

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

1398843_pastedImage_0.png

Avatar

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

Avatar

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

Avatar

Level 3

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

1425165_pastedImage_1.png