@SAMSAL : Below is the thing that I am trying for: ------------------------------------------------------------------- Input file sample: (Which will have 40k+ records, with a header and data segments, with "|" separated columns.) DATE|CUST_ID|CUST_NAME|PAYMENT_AMOUNT|PAYMENT_TYPE|CARD_TYPE 2024-11-29|123|Test1|0.0100|Credit Card|Visa 2024-11-29|456|Test2|10.00|Credit Card|Master 2024-11-29|789|Test3|500.00|Credit Card|American Express ------------------------------------------------------------------------- Expected output: This should be in a file with column having fixed length and sent to the remote server using the 'putSFTP' processor. 20241129Visa Test1 0.01 Credit 20241129Master Test2 10.00 Credit 20241129American Express Test3 500.00 Credit -------------------------------------------------------------------------- I am storing the input data in a database table using the 'putDatabaseRecord' processor and retrieving it using the 'executeSQL' processor (using SQL query adding fixed length for columns) convertAvroToJSOn output: [ { "date": "20241129", "card_type": "Master ", "payment_amount": "10.00 ", "payment_type": "Credit ", "cust_name": "Test1 " }, { "date": "20241129", "card_type": "Visa ", "payment_amount": "0.01 ", "payment_type": "Credit ", "cust_name": "Test2 " } ] SplitJSON to split the JSON and evaluateJSON path to get each attribute value Update attribute to place value in require output pattern ( (date)(card_type)(cust_name)(payment_amount)(payment_type) ) Merge all the content into single file and put it in a file.
... View more
