IMPORTANT:
this is not a Support Forum! Experienced users might answer from time to time questions posted here. If you need a professional and reliable answer, or if you want to report a bug, please contact Altova Support instead.

Mapping json array to text file Options · View
Pawel
Posted: Saturday, November 16, 2019 9:24:36 PM
Rank: Newbie

Joined: 10/30/2019
Posts: 7
Location: Poland
I have a problem when trying to map array of bank accounts for company/entity from json input file to a text file. During mapping the account numbers from json array (when there is more then one bank account) overwritte so from per example 4 bank accounts I have only one output - last account number form array. What I would like to see in the output text file is for each account number in the array there will be additional line of data created (any other data of an entity but account number will be the same) so if entity has 4 bank account numbers in the json array there will be 4 lines of data.

Any help will be grately appreciated.

Pawel.

I am adding json output example, final txt file example with warnings about overwritten bank account string values, screen shot of the mapping.

File Attachment(s):
text output and warnings.JPG (263kb) downloaded 0 time(s).

Pawel attached the following image(s):
json first output with array of bank.JPG
current mapping settings.JPG

that
Posted: Monday, November 18, 2019 12:30:54 PM
Rank: Advanced Member

Joined: 6/16/2006
Posts: 415
Location: AT
To create one row per account number, you simply connect the account number string to the Rows target.
Pawel
Posted: Monday, November 18, 2019 10:08:00 PM
Rank: Newbie

Joined: 10/30/2019
Posts: 7
Location: Poland
Hello,

Thank you for your reply. I have connected strings from "accountNumbers" array to the Rows node of output txt file and at the same time to "accountNumbers" data node. It works now how I intended.

File Attachment(s):
fixed -resolution output.JPG (288kb) downloaded 3 time(s).

Pawel attached the following image(s):
fixed -resolution.JPG

Users browsing this topic
guest

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Use of the Altova User Forum(s) is governed by the Altova Terms of Use.