Hi All,
I’m looking for an approach to generate a transformed file where column values will be replaced with Target values from a mapping sheet dynamically. So there will be two input files-1.Extract ,2.Mapping(sample below)
Extract:
BU VENDOR SITE
xx BU yy 101
pp BU yy 102
Mapping:
Expected output:
BU VENDOR SITE
US BU ABC Inc. 101
CA BU ABC Inc. 102
Any approach to achieve this dynamically will be very helpful. As the Columns names can change for Mapping & Extract files.
