2019-03-06 15-43-55
Ricardo de Freitas
44Views
4Comments
[CSVUtil] Mapping of CSV using the name of the column
Question
Forge
Service
csvutil
Service icon
CSVUtil
Forge component by Wei Zhu
Application Type
Service
Service Studio Version
11.53.43 (Build 62091)
Platform Version
11.18.1 (Build 37828)

Hi,

I have a question that can maybe turn into a idea for a future release if it's currently not possible.


I currently need to import csv files but the columns I need to map might be presented in different columns in certain files.


For instance: 

List to be filled:


CSV File1 (viewed in Excel):


CSV File 2 (viewed in Excel) :


As seen above, in both files there is a 'Field A', 'Field B', 'Field C' but 'Field C' is in a different position in both files.

Is there a way I can (automatically) map the columns based on the name of the column for instance as opposed to the order in which they appear? 


Using the structure I have for File 1 will map the values of 'Random Field A' instead of the values or 'Field C'.


Thanks in advance.


Regards,

Ricardo

0
0
19 Apr

Hi Ricardo,

Would you mind sharing the action name you're using with this extension?


Thanks,

Narendra

0
0
26 Apr

Hi Narendra, good one, I should have mentioned it.

The action name is: "LoadCSV2RecordList".


Regards,

Ricardo

0
0
26 Apr

Replying to Ricardo de Freitas' comment on 26 Apr 2023 11:25:19

Hi @Ricardo de Freitas ,

Have you got any solution for this problem?

We are also looking to map CSV by header names.

Regards,

Nitin

0
0
01 Sep

Replying to Nitin Chavan's comment on 01 Sep 2023 11:25:07


Hi Nitin,

I unfortunately couldn't find an alternative workaround either than using a different structure for each file that had a different set of headers.


Hopefully they add the possibility to define which headers we want to use in a future release.


Regards,

Ricardo


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