Skip to main content
hemantb0002
hemantb0002
Known Participant
October 21, 2022
Question

How to parse CSV/Excel file and insert records into DB if number of columns are dynamic(not fixed)

  • October 21, 2022
  • 2 replies
  • 0 views

There is a requirement where i need to parse csv/exel file and insert data into database. But the problem is number of columns can be different each time.

I have tried to use available plugins but it's not working.

Thanks,

Hemant

2 replies

stefanhelzle0001
stefanhelzle0001
Brainy
October 21, 2022

A dynamic number of columns is always a problem. What would you do with the data later on, not knowing the structure? I would try to push back requirement back.

S
sairamsatyanarayanam0001
October 21, 2022

you can try it using updateDictionary() when ever the new column is added add to that dictionary and run process model get insert into database....you can try may be it works..

Thank you.

Terms & ConditionsAccessibility statement