topic RE: CSV: Too many fields in Product Forum

CSV: Too many fields

rpatraining.wavicle — Fri, 02 Jun 2023 17:27:00 GMT

Hi,

i have a csv data of 260 columns with approximately 3000 rows of data. some data may be blank. but i would need to manipulate some data using collections. but when i try to import the csv file into collection, Blue Prism says "Too Many Fields". but when i tried by removing some columns say 6 columns of data, the remaining 254 columns were able to get into the collection. i came to know about the size of a column count is max 254.

Could anyone help me in getting the CSV Data (260 columns) into a collection?

------------------------------
Thanks
Raj Prabhu
RPA Developer
------------------------------

RE: CSV: Too many fields

harish.mogulluri — Sat, 03 Jun 2023 21:31:00 GMT

Hi raj prabhu,

Which version of blue prism you are using?

Are you able to provide the sample data set?

Did you check with blue prism support about any limitation around size of the column?

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------

RE: CSV: Too many fields

harish.mogulluri — Sat, 03 Jun 2023 21:42:00 GMT

In case if there is a limitation around columns.

I probably write code stage and break down the data in to two different collection

Break down the columns in the csv file itself like below

(Below steps you can automate . You need to play around to achieve this.)

1) copy and paste first 150 columns in new worksheet( sheet2)

2) copy and paste remaining columns in diff worksheet( sheet3)

Get the data from sheet2 and output is in coll1

Similarly get the data from sheet3 and out put is coll2.

Depends on the datset and manipulation you can try different approaches.

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------

RE: CSV: Too many fields

Tejaskumar_Darji — Tue, 06 Jun 2023 05:26:00 GMT

Check out this threads as well discussing about the similar scenario -

https://community.blueprism.com/discussion/importing-data-to-collection-from-csv-using-oledb

https://community.blueprism.com/communities/community-home/digestviewer/viewthread?MessageKey=16adfb54-82e0-4699-bf49-d1142daeec53&CommunityKey=1e516cfe-4d1f-4de9-a9eb-58d15bf38c81#bm16adfb54-82e0-4699-bf49-d1142daeec53

------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------