About Acbx

Acbx · ‎06-07-2021

Hi Matt It doesn't work. I dont know why but it has created 5 more columns

Acbx · ‎05-19-2021

I'm trying the processor ReplaceText to change all my dot to comma, but i can't I really need some help here, please. This is my CSV file: MONEY (header) 109.29 I need this result MONEY (header) 109,28

Acbx · ‎05-17-2021

Hello I trying to put some data from my CSV to my database but i got some error. Settings UpdateRecord Settings about CSVRecordSetWriter My csv file: Region Country ItemType SalesChannel OrderPriority OrderDate OrderID ShipDate UnitsSold UnitPrice UnitCost TotalRevenue TotalCost TotalProfit Sub-Saharan Africa Chad Office Supplies Online L 1/27/2011 292494523 02/12/2011 4484 651.21 524.96 2920025.64 2353920.64 566105.00 Europe Latvia Beverages Online C 12/28/2015 361825549 1/23/2016 1075 47.45 31.79 51008.75 34174.25 16834.50 Middle East and North Africa Pakistan Vegetables Offline C 1/13/2011 141515767 02/01/2011 6515 154.06 90.93 1003700.90 592408.95 411291.95 Sub-Saharan Africa Democratic Republic of the Congo Household Online C 09/11/2012 500364005 10/06/2012 7683 668.27 502.54 5134318.41 3861014.82 1273303.59 Europe Czech Republic Beverages Online C 10/27/2015 127481591 12/05/2015 3491 47.45 31.79 165647.95 110978.89 54669.06

Acbx · ‎05-17-2021

Hello I need to change the name of the columns. Ex: 'item Type' became 'Item_Type' Region Country Item Type Sales Channel Order Priority Order Date Order ID Ship Date Units Sold Unit Price Unit Cost Total Revenue Total Cost Total Profit Sub-Saharan Africa Chad Office Supplies Online L 1/27/2011 292494523 02/12/2011 4484 651.21 524.96 2920025.64 2353920.64 566105.00 Europe Latvia Beverages Online C 12/28/2015 361825549 1/23/2016 1075 47.45 31.79 51008.75 34174.25 16834.50 Middle East and North Africa Pakistan Vegetables Offline C 1/13/2011 141515767 02/01/2011 6515 154.06 90.93 1003700.90 592408.95 411291.95 Sub-Saharan Africa Democratic Republic of the Congo Household Online C 09/11/2012 500364005 10/06/2012 7683 668.27 502.54 5134318.41 3861014.82 1273303.59 Europe Czech Republic Beverages Online C 10/27/2015 127481591 12/05/2015 3491 47.45 31.79 165647.95 110978.89 54669.06 i'm trying to use the processor ReplaceText But this is the result Region Country Item_Type Sales_Channel Order_Priority Order_Date Order_ID Ship_Date Units_Sold Unit_Price Unit_Cost Total_Revenue Total_Cost Total_Profit__Sub-Saharan Africa Chad Office Supplies Online L 1/27/2011 292494523 02/12/2011 4484 651.21 524.96 2920025.64 2353920.64 566105.00 Europe Latvia Beverages Online C 12/28/2015 361825549 1/23/2016 1075 47.45 31.79 51008.75 34174.25 16834.50 Middle East and North Africa Pakistan Vegetables Offline C 1/13/2011 141515767 02/01/2011 6515 154.06 90.93 1003700.90 592408.95 411291.95 Sub-Saharan Africa Democratic Republic of the Congo Household Online C 09/11/2012 500364005 10/06/2012 7683 668.27 502.54 5134318.41 3861014.82 1273303.59 Europe Czech Republic Beverages Online C 10/27/2015 127481591 12/05/2015 3491 47.45 31.79 165647.95 110978.89 54669.06 Sub-Saharan Africa South Africa Beverages Offline H 07/10/2012 482292354 8/21/2012 9880 47.45 31.79 468806.00 314085.20 154720.80 Can someone help me please?

Date Registered	‎05-17-2021 09:29 AM
Last Visited	‎06-17-2021 06:51 PM
Total Messages Posted	4

Re: Nifi ReplaceText how can i change dot to comma

Nifi ReplaceText how can i change dot to comma

NiFI: how can i convert string to date

NiFI: how can i change space to underscore with Re...