[CSVUtil] Matching column names with attributes of database

Forge Component
Published on 2017-10-09 by Wei Zhu
21 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.


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.