We receive the .DAT files directly from the client which for the normal process that we have in place, ETL using ODI, we are open it in excel. But I wanted to know if there is a way to convert it or read it because we need to store the data of it in a table. ... View more

Hello everyone ! I tried with Embedded schema, like Shu mentioned, and now everything is working perfectly. I feel so bad that it was so easy and simple, just few processors...anyway, thank you for your time and help, I really appreciate it ! Kind regards, Stefan ... View more

Hello @Shu, I didn't added here but of course I tried also with upper letters and still the same issue with ConvertRecord. With the EvaluateJsonPath, same issue again. I tried many other things but nothing worked. I was thinking that it will be really easy to output a file from a simple select query from a table but it seems that is not like that.. ... View more

Json input: [ { "INV_IDN" : "247048764", "INV_NUMBER" : "181120060", "USR_MDF" : "15/03/2018 08:34:00 by LDL", "INVISSDAT" : "15/03/2018", "INVCLICOD" : "FUNDQ", "INVCLINAM" : "FUNDQUEST", "INVCLI_REGCOUNTRY" : "FR", "INVOICECLASS" : "CUS - assujetti in EU outside Lx", "CORCLICOD" : "BNPAMFR", "OFOCHINMB" : "20173748", "BSNCTGDSC" : "Fund Data Management", "BSNCTGCOD" : "LIS", "BSNCTGDSPCOD" : "FDM", "INVTYP" : "Credit Note", "INVSTU" : "Validated", "INVORGCOD" : "LU", "CRYCOD" : "EUR", "AMNWTHVAT" : "-7,543.23", "AMNWTHVATINEUR" : "-7,543.23", "MEDIAFEESINEUR" : "0", "KCFEESINEUR" : "-7543.23" } ] Json schema: { "type": "record", "name": "DnpReport", "fields" : [ {"name": "inv_idn", "type": ["null", "string"]}, {"name": "inv_number", "type": ["null", "string"]}, {"name": "usr_mdf", "type": ["null", "string"]}, {"name": "invIssDat", "type": ["null", "string"]}, {"name": "invCliCod", "type": ["null", "string"]}, {"name": "invCliNam", "type": ["null", "string"]}, {"name": "invCli_RegCountry", "type": ["null", "string"]}, {"name": "invoiceClass", "type": ["null", "string"]}, {"name": "corCliCod", "type": ["null", "string"]}, {"name": "ofoChiNmb", "type": ["null", "string"]}, {"name": "bsnCtgDsc", "type": ["null", "string"]}, {"name": "bsnCtgCod", "type": ["null", "string"]}, {"name": "bsnCtgDspCod", "type": ["null", "string"]}, {"name": "invTyp", "type": ["null", "string"]}, {"name": "invStu", "type": ["null", "string"]}, {"name": "invOrgCod", "type": ["null", "string"]}, {"name": "cryCod", "type": ["null", "string"]}, {"name": "amnWthVat", "type": ["null", "string"]}, {"name": "amnWthVatInEur", "type": ["null", "string"]}, {"name": "mediaFeesInEur", "type": ["null", "string"]}, {"name": "kcFeesInEur", "type": ["null", "string"]} ] } ... View more

Hello @Shu, @Rahul Soni, Do you have any other ideas ? Thank you ! Kind regards, Stefan ... View more

Hello @Rahul Soni, Since beggining I tried with null like default values but still I receive that error. Also I validated the JSON so is OK, here is my JSON: { "type": "record", "name": "DnpReport", "fields" : [ {"name": "inv_idn", "type": ["null", "string"]}, {"name": "inv_number", "type": ["null", "string"]}, {"name": "usr_mdf", "type": ["null", "string"]}, {"name": "invIssDat", "type": ["null", "string"]}, {"name": "invCliCod", "type": ["null", "string"]}, {"name": "invCliNam", "type": ["null", "string"]}, {"name": "invCli_RegCountry", "type": ["null", "string"]}, {"name": "invoiceClass", "type": ["null", "string"]}, {"name": "corCliCod", "type": ["null", "string"]}, {"name": "ofoChiNmb", "type": ["null", "string"]}, {"name": "bsnCtgDsc", "type": ["null", "string"]}, {"name": "bsnCtgCod", "type": ["null", "string"]}, {"name": "bsnCtgDspCod", "type": ["null", "string"]}, {"name": "invTyp", "type": ["null", "string"]}, {"name": "invStu", "type": ["null", "string"]}, {"name": "invOrgCod", "type": ["null", "string"]}, {"name": "cryCod", "type": ["null", "string"]}, {"name": "amnWthVat", "type": ["null", "string"]}, {"name": "amnWthVatInEur", "type": ["null", "string"]}, {"name": "mediaFeesInEur", "type": ["null", "string"]}, {"name": "kcFeesInEur", "type": ["null", "string"]} ] } Kind regards, Stefan ... View more

Hello @Shu, Unfortunately, both flows didn't work. First one, with ReplaceText having the properties you mentioned still outputted empty values even though the attributes are the same. For the second one with ConvertRecord, I receive this error: Failed to process StandardFlowFileRecord[...] will route to failure: java.lang.ArrayIndexOutOfBoundsException: -40 java.lang.ArrayIndexOutOfBoundsException: -40 I even try to convert the Avro to JSON and then to pass to ConvertRecord but still the same error... Any help will be welcomed ! Thank you ! Kind regards, Stefan ... View more