CSV: Too many fields

[RPA_TrainingWav]

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
------------------------------

[harish.mogulluri]

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
------------------------------

[harish.mogulluri]

In case if there is a limitation around columns.

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

Or 

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
------------------------------

[Tejaskumar_Darji]

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-469...

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

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