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

SOLVED

ACS Reconciliation | additional data to reconciliation activity

Avatar

Level 2

Is there a way to pass "additional data" (Similar to Query-> additional data) to reconciliation activity when Load File from FTP.  Here is my Technical workflow.

 

Load File->Reconciliation -> Update Data. 

 

The reason i'm looking for additional data because the input file do not have the data attribute that i would like to use in the reconciliation. The reconciliation seems only allow to lookup a variable as opposed to an input string. 

 

 

@johnwwilcoxmba 

 

1 Accepted Solution

Avatar

Correct answer by
Level 6

Yes.  You can use an enrichment activity to add that data.

View solution in original post

3 Replies

Avatar

Correct answer by
Level 6

Yes.  You can use an enrichment activity to add that data.

Avatar

Level 2

Thanks, In the enrichment activity, i would assume i will take the primary set as "load file" ( this has got the main data to be ingested), now, i'm looking to include the output from reconciliation as an additional element before passing the enriched data set to "update' activity. However, I can only select a variable from the primary data as an additional field (so that i can use that variable in the update step). 

 

Am I looking the correct way, or the primary data (inside enrichment) should be the reconciliation?