I have 2 data sets that are connected to a database. Datasets are updated everyday.
Data set 1 -
Customer Name Transaction Type
Data set 2 -
Customer Name Field 2
For workflow processing, requirement is to modify all records from Dataset 1 based on the below logic --
- All incoming records with field (transaction type ) and value (T1) need to be assigned K1 value on the same field. <Open to a new field if solution is simpler>
- All incoming records with field (transaction type ) and value (T2) need to be assigned K2 value on the same field.
<Open to a new field if solution is simpler>
Only after dataset 1 is modified per above logic, I can continue further workflow processing by joining with dataset 2 based on above 2 fields (Customer Name, Field 2).