map the decompressed field which returns an xml to target fields
Jun 13, 2017 at 09:42 AM|111 Views | Last edit Jun 13, 2017 at 10:29 AM 2 rev.
Hi,
I have a scenario where I am getting a field which has decompressed data GZIP base 64 encoding. I ma getting an XML in the field Compresseddata from source. I am decompressing it. I am able to decompress it but I dont know how to map it with target fields.
it was mapped like compresseddata-UDF-compresseddata, Message-Message and go on. since I am getting the compressed data in compresseddata field, I am decompressing it. it is decompressing as an xml. so how to map it with target fields ?
In the UDF, you need to parse the xml and retrieve the values of fields and then map to target. The approach would be something like I suggested in below thread.
Add comment