Hi Team, how to sort this below output in Ascending order  by maintaining same space in both header values. I've tried using query record but couldn't able to add spaces using SPACE function. but space which i've given is considering as SPACE(numeric) value instead of INT. input: NO CUSTOM.;NO INCSUPB;NO ALLBPBM ;IMPORTE BRUTO;DESCUENTO;IMPORTE NETO 0000000023;123548    ;999888     ;875,92       ;176,88   ;699,04 0000000012;123547    ;777666     ;2347,04      ;591,84   ;1755,2   Expected Output: NO CUSTOM.;NO INCSUPB;NO ALLBPBM ;IMPORTE BRUTO;DESCUENTO;IMPORTE NETO 0000000012;123547    ;777666     ;2347,04      ;591,84   ;1755,2 0000000023;123548    ;999888     ;875,92       ;176,88   ;699,04 ... View more

HI All,   Im getting below error  after new fileds are being added to the payload from Kafka OpenTX, datatype: double precision charges, Datatype: string note:before these 2 fields added to the payload its working fine with existing json reader and writer Error: 05:25:40 UTCERRORConsumeKafkaRecord_2_6[id=8f8pq352c-0rcb] Failed to parse message from Kafka using the configured Record Reader. Will route message as its own FlowFile to the 'parse.failure' relationship: org.apache.nifi.serialization.MalformedRecordException: Successfully parsed a JSON object from input but failed to convert into a Record object with the given schema - Caused by: org.apache.nifi.serialization.record.util.IllegalTypeConversionException: Cannot convert value [[Ljava.lang.Object;@6b9b8a0c] of type class [Ljava.lang.Object; for field invoiceLineList.ecoTaxValues to any of the following available Sub-Types for a Choice: [ARRAY[STRING], ARRAY[DOUBLE]] input payload: { "Identifier":"123456", "creationDate":"2024-11-22T12:22:01.331894Z", "docType":"01", "currency":"INR", "taxCode": [null,null,null,"04",null,null,null,null,null], "invoiceLineList": [ { "line":1, "charges":["009",null,null], "OpenTX": [0.3,0.9,null,null] }, { "line":2, "charges":["002",null,null], "OpenTX": [0.1,1.9,null,null] } ] } below are the json reader and writer configs. JSONTreeReader: JSONrecordSETWriter i've tried changing reader to AVRO reader using "Confluent Content-Encoded Schema Reference" in the Avro Reader "Schema Access Strategy" field and keeping JsonRecordsetwriter same as above but still its not working, Can anyone help me here? @SAMSAL    thanks!! ... View more

HI Team,           we have jar executable which is running fine in Nifi 1.15 version  after we upgraded to 1.17 , when we tried to execute that jar its showing as invalid or corrupt jar file. when we checked java version both nifi and jar executable are on same version i.e. java 8  however we noticed that jdk versions are different from previous version to latest version nifi 1.15 having openjdk version 1.8.0_312 Nifi 1.17 having openjdk version jdk1.8.0_332 suspecting this caused issue, however we are not able to update the jar.   Can anyone help here what might be the issue here and how we can solve this issue.   thanks ... View more

Hi All,   How to fetch all files in a directory based on one specific file arrive in that directory   Ex: when i've file with extension .trg is there i've to fetch all files (irrespective of name and extension of these files) in that directory list   there are .txt, .xml and . xlsx files are there in \\server\share\test\ all these files should be fetched whenever there is file with extension .trg arrive     I've tried this scenario using    ListSMB-->wait/notify--> Fetchsmb  but didn't working   are there any solutions suggested by anyone?   ... View more