Hi All,
I have a dataflow in my job where the data is extracted from 8 different JDE markets as shown in attachment.
The values starting with 'U' inside the brackets are the library names/Table owner. I have a requirement where the target data has a new output column- 'Library' and the data corresponding the that market should populate the value of the library that it is coming from.
For instance, the data corresponding to 'Italy' should populate the 'Library' field as -'UR064PBD'.
Could someone please suggest what function should be called t this column in order to populate the fields automatically.
Thanks in advance.
Sindhura Thota