To change the key names of your JSON you can transform it with JOLT. The Processor name calls JoltTransformJSON   In the property you can "Jolt Specification" you can insert following code, that would be change your key from ServiceGroup to service_group and afterwards you can send the flowfile to the sql processor..   [ { "operation": "shift", "spec": { "ServiceGroup": "service_group", "*": "&" } } ]   ... View more

Hi,  i tried a solution for you: 1) GenerateFlowFile Its your GetFile Processor to get the csv file   2) ConvertRecord Convert with CSVReader to JsonRecordSetWriter   3) SplitJson Split each bbject (csv row) with    $.*   as path   4) EvaluateJsonPath Add dynamicilly property with name   filename   and value   $.ID   to get the ID as filename on flowfile attribute   5) UpdateAttribute Add type of file to filename attribute value   ${filename:append('.csv')}     6) ConvertRecord Now is the question how to work.. You can convert json back to csv or you are working with wait/notify, so that you can overhand your "filename" attribute to your splitted csv flowfile.. ... View more

Hello,   you could use following regex [^^]+ with that you should get the whole content.   Please take a look at the property "Maximum Capture Group Length" at the ExtractText Processor, that its not too short.  ... View more

The problem is because your value is higher than the maximum of an integer   Change  "=toInteger" to "=toLong"   ... View more

maybe you should set for all or just for t1/t2.. fields an Alias like t1.CODE_CLOCK_ID as CODE_CLOCK_ID_s26, t1.COMPANY_CD as COMPANY_CD_s26, t1.GROUP_SEGMENT_L1 as GROUP_SEGMENT_L1_s26, t1.GROUP_SEGMENT_CD as GROUP_SEGMENT_CD_s26, t2.CODE_CLOCK_ID asCODE_CLOCK_ID_s27, t2.COMPANY_CD as COMPANY_CD_s27, t2.GROUP_SEGMENT_L1 as GROUP_SEGMENT_L1_s27, t2.GROUP_SEGMENT_CD as GROUP_SEGMENT_CD_s27   Greets   ... View more