Member since
08-18-2019
56
Posts
11
Kudos Received
18
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
641 | 11-15-2023 05:38 AM | |
2326 | 07-12-2023 05:38 AM | |
695 | 01-10-2023 01:50 AM | |
983 | 12-06-2022 12:08 AM | |
3813 | 12-02-2022 12:55 AM |
11-28-2022
07:47 AM
Hello @Techie123 I added a operation to your Jolt Specification, try it with: [
{
"operation": "shift",
"spec": {
"data": {
"*": {
"Id": "[&1].Id",
"Date": "[&1].Date",
"$": "[&1].array_Ind"
}
}
}
}, {
"operation": "modify-overwrite-beta",
"spec": {
"*": {
"array_Ind": "=intSum(1,@(1,array_Ind))"
}
}
}, {
"operation": "modify-default-beta",
"spec": {
"*": {
"Record": "=concat('Record ',@(1,array_Ind))"
}
}
}
] Greetings
... View more
11-23-2022
02:40 AM
Hello, quick and dirty solution: In Apache Nifi there you can find the SplitText Processor, there you can set the Line Split Count to 1. Those splitted Flowfiles get some fragment attributes to merge them together again. So after splitting you can merge directly again with MergeContent Processor. For this processor you set properties like: - Merge Strategy: Defragment - Delimiter Strategy: Text - Header: [{" - Footer: "}] - Demarcator: "},{" After that we can split key values with ReplaceText Processor with following properties what needs to be changed from default: - Search Value: \| - Replacement Value: ":" Greetings
... View more
11-09-2022
12:18 AM
1 Kudo
@Techie123 can you show the properties of the processor? Can you maybe check if the base64 string length is for real longer than the max integer value? With ExecuteStreamCommand you can resize your image. Attributes should actually be kept small, so it's not the optimal solution either. Maybe you can also define the workflow a bit, for which you need the string in an attribute - maybe you can work around that?!
... View more
11-08-2022
05:41 AM
1 Kudo
Ok, there are 2 cases. 1. You use Base64EncodeContent to encode your image and after that with ExtractText there you write the content of your flowfile to an attribute. There you have to set the property Maximum Capture Group Length to your desired length. I would prefer that you also set Maximum Buffer Size to ~10 MB that the process gets fully buffered. 2. Use Processor ExecuteStreamCommand Properties: Command Arguments: -w 0 Command Path: base64 Output Destination Attribute: attribute.base64 Max Attribute Length: your desired length If you dont work with one of those 2 cases, then please describe your flow 🙂
... View more
11-08-2022
02:48 AM
1 Kudo
Hello, the maximal value length of an attribute is 2147483647 (max Integer) Greetings
... View more
11-08-2022
02:00 AM
Hello, in your script body you dont manipulate the content. You add an Attribute to your flowfile (which works 😀) Maybe you can have a look at https://community.cloudera.com/t5/Community-Articles/ExecuteScript-Cookbook-part-2/ta-p/249018/page/2 But in case you don´t need to do it via ExecuteScript Processor, you could use JoltTransformJSON Processor. On conficuration you can set for the property Jolt Specification following value: [
{
"operation": "default",
"spec": {
"gender": "male"
}
}
] After that your JSON should be extended with your key-value-pair. Greetings
... View more
11-03-2022
07:40 AM
Try that: [
{
"operation": "shift",
"spec": {
"*": {
"Ean": "[&1].gtin",
"ean": "[&1].gtin",
"EAN": "[&1].gtin",
"EanCode": "[&1].gtin",
"EAN-Code": "[&1].gtin",
"EANCode": "[&1].gtin",
"Ausdr1": "[&1].gtin",
"Bestand": "[&1].qty",
"Menge": "[&1].qty",
"Stock": "[&1].qty",
"stock": "[&1].qty",
"Verfügbare Menge (Kennzahl)": "[&1].qty",
"Verfügbare Menge": "[&1].qty"
}
}
}, {
"operation": "modify-default-beta",
"spec": {
"*": {
"update_date": "2022-11-03",
"supplier_name": "demo",
"file_name": "test"
}
}
}
] Greetings
... View more
11-02-2022
02:51 AM
1 Kudo
Hello, this does not seem to be possible for me. You can use before JOLTTransformation the Processor EvaluateJsonPath to store the date to an attribute and afterwards you could do your convertation with expression language function in JOLT. Greetings
... View more
11-02-2022
12:59 AM
Hello, your CRON-Expression means that it gets exectued at 08:05am, every day starting on the 1st, every month. To execute the processor daily based on 08:05 am then you need to set 0 5 8 ? * * * Greetings
... View more
10-26-2022
08:13 AM
Hello, can you try it with: [
{
"operation": "shift",
"spec": {
"orderItems": {
"*": {
"id": "orderItems[&1].text01",
"typeId": "orderItems[&1].text02",
"itemVariationId": "orderItems[&1].text03",
"quantity": "orderItems[&1].text04",
"attributeValues": "orderItems[&1].text05",
"vatField": "orderItems[&1].text06",
"amounts": "orderItems[&1].amounts"
}
},
"*": "&"
}
}
] Let me know if there needs something to change. Greetings
... View more