SAP Knowledge Base Article - Preview

3763603 - Task calling a lookup function fails with error "Could not find column <XXXXX> that contains the value looked up in the specified table <XXXXX.csv>" - SAP Cloud Integration for data services

Symptom

  • A CI-DS task fails with the following error:
    • RES-20116 |SESSION XXXXX|DATAFLOW XXXXX|STATEMENT <GUID::'XXXXX' QUERY XXXXX> Could not find column <XXXXX> that contains the value looked up in the specified table <XXXXX.csv>. Ensure that the lookup table has this column defined and the column name has been spelled correctly.
  • The lookup function is called correctly.
  • The file called in the lookup function has the correct structure and metadata maintained in the file format datastore. 


that contains the value looked up in the specified table " - SAP Cloud Integration for data services"> Read more...

Environment

SAP Cloud Integration for data services

Product

SAP Cloud Integration for data services 1.0

Keywords

CI-DS, cids, task, fail, error, find, column, contains, value, looked, up, lookup, specified, table, cache, datastore, atl, correct, structure, metadata , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.