Highlighted

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

Avatar

Avatar

solbums48271185

Avatar

solbums48271185

solbums48271185

16-01-2018

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.

Replies

Highlighted

Avatar

Avatar

davidk46719882

Avatar

davidk46719882

davidk46719882

19-01-2018

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

1398843_pastedImage_0.png

Highlighted

Avatar

Avatar

solbums48271185

Avatar

solbums48271185

solbums48271185

22-01-2018

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

Highlighted

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb

02-02-2018

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

Highlighted

Avatar

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239

Avatar

florentlb

Total Posts

1.1K

Likes

235

Correct Answer

239
florentlb

20-02-2018

Hi,

Any update on your issue?

Florent

Highlighted

Avatar

Avatar

wkt85768776

Avatar

wkt85768776

wkt85768776

22-02-2018

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

1425165_pastedImage_1.png