Insert field data on each row of uploaded and parsed content

Insert field data on each row of uploaded and parsed content

Hi,

On the upload and parse content below, I want to insert data into each row that I need on the parsed input to the other form so the data can be grouped by this field, but it can't be on the uploaded .csv. 

How can I do this?

  2. fileContent = input.Cruise_Sales_Upload.content;
  3. rowlis = fileContent.toList("\n");
  4. i = 0;
  5. for each  rl in rowlis
  6. {
  7. if(i > 0 && i < rowlis.size() - 1)
  8. {
  9. lis = rl.toList();
  10. ppstfNewRecordID = insert into Preferred_Partner_Sales_Totals_Form
  11. [
  12. Added_User=zoho.loginuser
  13. Supplier_Sub_Type=lis.get(0)
  14. Company_Name=lis.get(1)
  15. Cruise_Sales_2023=if(lis.get(2).tostring() == "",0,lis.get(2).todecimal())
  16. Cruise_Sales_2022=if(lis.get(3).tostring() == "",0,lis.get(3).todecimal())
  17. ];
  18. //fetch ppstf recird
  19. ppstfRecord = Preferred_Partner_Sales_Totals_Form[ID = ppstfNewRecordID];
  20. //
  21. if(ppstfRecord.Company_Sub_Type = "Cruise Line" && ppstfRecord.Cruise_Sales_2023 = null && ppstfRecord.Cruise_Sales_2022 = null && ppstfRecord.Cruise_Sales_2020 = null && ppstfRecord.Cruise_Sales_2021 = null)
  22. {
  23. //
  24. delete from Preferred_Partner_Sales_Totals_Form[ID = ppstfNewRecordID];
  25. }
  26. }
  27. i = i + 1;
  28. info rowlis;
  29. }