CODEWITHSUNDEEP
azureazure-search-.net-sdk
Vitor Alcântara Batista
Vitor Alcântara Batista

Reputation: 63

How to concatenate multiple columns/fields from CSV to a single string field into Azure Index

I have a CSV in an Azure blob storage. I created a data source, an index, and an indexer in Azure Search. I can map one-to-one fields from origin to destination, but I want to create a new field in the index that concatenates all text fields from CSV.

How can I achieve this?

Upvotes: 0

Views: 99

Answers (1)

Sampath
Sampath

Reputation: 3478

Azure AI Search indexers use field mappings to establish the data path between source and destination fields. Implicit mappings occur when field names and data types match, while explicit mappings are defined for cases where they don't match.

  • Field mappings are added to the fieldMappings array in the indexer definition. Each mapping consists of sourceFieldName, targetFieldName, and optional mappingFunction properties.

  • Created a sample indexing in Azure AI Search with Azure.Search.Documents client library using NET.

Enter image description here

Enter image description here

  • Followed this document to map fields in indexers for Azure AI Search.

Enter image description here

  • Use this document and git for mapping enriched output to fields.

  • Follow this git for information on how to field map complex types.

Upvotes: 0

Related Questions