I have one Source =”ABC.csv” and a lookup “a_alert”.
ABS.csv contains fields such as ID, Description (200 free character field)
a_alert contain one field a_type e.g. Monitoring, Access, Deployment
I need a query which can match Description from ABC.csv to a_type from a_alert and create the append a field in the ABC.csv
Final output should be
ID Description a_type
1 User having Access Issue Access
2 …. Monitoring ……. Monitoring
3 … product having successful deployment Deployment
4 Access Issue with .. type of Users Access
... View more