Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Not getting look up field (Id) on rejected updates

Hi people, 

 

How can i get the Id (look up field) of the row that was rejected during the update? I've tried doing different things like adding a t-map but nothing, guess it has something to do with the join that is made on the update. See attached files.

 

Thnx!

 

 

Labels (2)
4 Replies
manodwhb
Champion II
Champion II

@JoseQ,you will not get the Id for the rejected record from tSaleforce components. since you need to verify the records based on source that i believe that reference Key is missing to update.

Anonymous
Not applicable
Author

Thnx for your quick answer @manodwhb. But how can i associate the error message to especific Id? 

My input file only contains a list of Salesforce ids, how can i get the ones that wasn´t updated?


img3.JPG
TRF
Champion II
Champion II

Maybe I misunderstoo your question.

Any way, are you sure the Ids you provide for the lookup match with the object type you want to join?

Anonymous
Not applicable
Author

Yes, actually if you see i only have a few rejections. The thing is:

-Input file only contains a few Salesforce ID that i need to update. 

-T-map and all componets are working as espected. 

-Tfile for updated records are showing rows and info perfectly.

* Issue, the rejected tfile contains all the rows that were rejected but only showing message error, is not linked to the Id that generates the error, Id column is null. Ej.: 

Id         Error

            FIELD_CUSTOM_VALIDATION_EXCEPTION::--

            INVALID_CROSS_REFERENCE_KEY:invalid cross reference id:--

How can i get these 2 ids? i only have an error description on the file.