215
Views
2
Comments
[CSVUtil] Matching column names with attributes of database
Question
csvutil
Service icon
Forge asset 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 

2018-11-06 14-26-44
Suraj Borade

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

2021-06-21 12-37-59
Wei Zhu

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

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.