Unable to write sldb file to file system
Hi, We are currently having a use case where we are writing data into Kafka. We have observed intermittent failures with the error description -"Unable to write sldb file to file system". Upon ins...
Forum Discussion
Hi rdill,
We don't have the copybook parser snap.so that's why I am trying to read this cobol file using this python script and passing the output as Json.
Sp could you please help me how to execute this python script in script snap
this is my copybook layout and sample file how to convert this into csv using the python script
Hi @vaidyarm,
I’ve put together a pipeline where I simulate your case. In it I propose two solutions. Assuming that the $olditem array is anywhere in the hierarchy of the input document:
- If you put
jsonPath($,"$..olditem")[0].map(x=>{"row":x.id})in an Expression in a Mapper, and assign it to $batch Target Path, you should get the output you described. - The second solution has 2 Mapper Snaps. In the first one, I extract $olditem from anywhere in the hierarchy and assign it to $batch. In the second Mapper, i designate
$batch[*]as Mapping Root, and I proceed to remap the array elements.
Here’s the pipeline:
Array_key_value_pair_2020_07_01.slp (9.0 KB)BR,
DimitriThanks a Lot !!,
The root element approach greatly resolved most of the deep JSON Section problems.
one of the situations where I had multiple such cases,
Ex: hierarchy as main >> subsection >> item >> item detailsstarted mapping the deepest section first using root path in mapper and finally the outermost part. it distributed the arrays as required
- If you put
Can Anybody Help on this ?
