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.

sort records from csv file with multiple rows Options · View
rautr
Posted: Wednesday, March 27, 2019 1:05:28 AM
Rank: Member

Joined: 3/6/2018
Posts: 28
Hi All,

Please find attached sample mapping. I want to create sample2 file from sample1 sorted by rowNumber.
Please help.

Thanks.


rautr attached the following image(s):
Sort.PNG

K101
Posted: Wednesday, March 27, 2019 7:16:53 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 558
Do you actually want to create both sample1 and sample2? It's clear from your screenshot that you can simplify the mapping. Rather than duplicating the Rows and filtering to one or the other, just use an if-else to supply either "error1" or "error2" to your "error" column depending on that boolean condition. Then, insert your Sort between the input Rows and the output Rows, and you should be good to go.

If you're fine with the way sample1 is being created now, then just add another text component with the same CSV structure as sample1, and insert your Sort component between sample1's Rows and sample2's Rows.

If you're not sure, please attach your actual files to your original post.
intsales
Posted: Wednesday, May 1, 2019 5:44:50 AM
Rank: Member

Joined: 4/3/2019
Posts: 24
Is 'Sort' a inbuilt function?
K101
Posted: Thursday, May 2, 2019 7:18:10 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 558
intsales wrote:
Is 'Sort' a inbuilt function?


Yes.
intsales
Posted: Thursday, May 2, 2019 6:48:15 PM
Rank: Member

Joined: 4/3/2019
Posts: 24
Thanks. was searching it in the libraries but it's available on the toolbar.
K101
Posted: Friday, May 3, 2019 6:02:35 AM
Rank: Advanced Member

Joined: 2/27/2009
Posts: 558
intsales wrote:
Thanks. was searching it in the libraries but it's available on the toolbar.


Ah, I see. Then, I should have said, no, it's not a function, it's a component.
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.