Importing csv file into a workflow and intersect it with query result

Avatar

Avatar
Boost 1
Level 1
malter68240968
Level 1

Like

1 like

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
malter68240968
Level 1

Like

1 like

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Boost 1
View profile
malter68240968
Level 1

20-01-2020

Hi everyone,

 

i would like to import a csv file with a list of customers into a workflow and intersect the imported data with the result of a query (matching can take place with one column like customer ID). How can this be done most efficiently? The csv data should not be imported to the ACS data model first.

 

Thank you in advance for your input and help!

View Entire Topic

Avatar

Avatar
Validate 1
MVP
bobbyjss
MVP

Likes

77 likes

Total Posts

108 posts

Correct reply

14 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 25
Give Back 10
View profile

Avatar
Validate 1
MVP
bobbyjss
MVP

Likes

77 likes

Total Posts

108 posts

Correct reply

14 solutions
Top badges earned
Validate 1
Contributor
Shape 1
Give Back 25
Give Back 10
View profile
bobbyjss
MVP

22-01-2020

This would need to be done using the Enrichment activity. You can configure it to accept data from two sources, and choose which is the primary source. You then enrich that data with data from the alternative source.