[CSVUtil] Matching column names with attributes of database

[CSVUtil] Matching column names with attributes of database

  
Forge Component
(20)
Published on 2017-10-09 by Wei Zhu
20 votes
Published on 2017-10-09 by Wei Zhu

How do I match the columns of the csv file with the attributes of the database, just like we have in the ExcelToRecordList 

Hi Rupinder,

Check what is the delimeter of your CSV file.

From Text extension, use Stringsplit action to split the CSV file for records and attributes and map accordingly.

Hope this helps.

Thanks

Suraj Borade

Hi Rupinde


Usually you need define the structure to match the CSV file columns and loading CSV to the structure list.

Then you can convert data from structure to your entity as you like.


This is same way when you create a bootstrap Action from Excel.

At that case, a structure named Excel_XXX will be created for this purpose.


Regards

Wei