|
|
Rank: Member
Joined: 9/10/2014
Posts: 14
|
Hi everyone,
do I need to manage a "value-map" with values from an external CSV file, any suggestions?
I tried to load the CSV file into an XML structure but then I don't manage to extract the values I need based on the input data.
marcokki attached the following image(s):
|
|
Rank: Advanced Member
Joined: 2/27/2009
Posts: 565
|
Just insert the CSV file as a separate component, then load the values you need from it using a filter. Then you need not use a value-map at all. Certainly there's no need to involve an XML file.
|
|
Rank: Advanced Member
Joined: 2/27/2009
Posts: 565
|
Here's an example. File Attachment(s):
 example.zip (2kb) downloaded 84 time(s).
K101 attached the following image(s):
|
|
Rank: Member
Joined: 9/10/2014
Posts: 14
|
Thanks for the reply but I probably misread the problem.
For example: given the file:
ROW HEADER1
ROW HEADER2
DETAIL ROW1a: FIELD1 FIELD2 FIELD3
DETAIL ROW1b
DETAIL ROW1c
DETAIL ROW1a: FIELD1 FIELD2 FIELD3
DETAIL ROW1b
DETAIL ROW1c
DETAIL ROW1a: FIELD1 FIELD2 FIELD3
DETAIL ROW1b
DETAIL ROW1c
FOOT ROW1
FOOT ROW2
I have to change a field (FIELD2) inside the DETAIL ROW1a line modifying the value with the one taken from an external file, an activity I could do with a value-map if the file didn't change frequently.
|
|
Rank: Member
Joined: 9/10/2014
Posts: 14
|
Resolved. I had an error in the structure that had made me climb on the mirrors.
The standard solution for importing a CSV and using a filter is the correct one to use.
Regards
Marco
marcokki attached the following image(s):
|
|
|
guest |
