|
Rank: Member
Joined: 10/30/2019 Posts: 15 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):
|
|
Rank: Advanced Member
Joined: 6/16/2006 Posts: 486 Location: AT
|
To create one row per account number, you simply connect the account number string to the Rows target.
|
|
Rank: Member
Joined: 10/30/2019 Posts: 15 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 77 time(s).
Pawel attached the following image(s):
|
|
Rank: Newbie
Joined: 1/30/2020 Posts: 1 Location: Chicago
|
Hi ,
I just started using the tool. we are converting JSON ==> TEXT file.
how can we save the output in to a file. ( As it currently showing in Output window).
Thanks, SxS sxs attached the following image(s):
|
|
Rank: Advanced Member
Joined: 6/16/2006 Posts: 486 Location: AT
|
sxs wrote:how can we save the output in to a file. ( As it currently showing in Output window).
When you're in the Output window, use the "Save Output File" command in the "Output" menu.
|
|
guest |