Creating a Header
Posted: Thu Oct 19, 2017 10:50 am
Another brainbuster for you guys. I have a set of data that looks like this:
AD43829T||||4,5
AF87571S||||4,5
CP06459X||||4,5
AD99586W||||4,5
CK71846A||||4,5
In the transformer, I want to add a header to this to make the output look like this:
File partially processed|Total-10|Accepted-0|Rejected-10|
AD43829T||||4,5
AF87571S||||4,5
CP06459X||||4,5
AD99586W||||4,5
CK71846A||||4,5
But only using 1 column. Is this possible? I used the code:
(("File partially processed"):"|":("Total":"-":Detail_Count):"|":("Accepted":"-":(Detail_Count - Reject_Count)):"|":("Rejected":"-":Reject_Count)):"|":(Link_RESP_EXTR.DATA [71,8]):"|":(Link_RESP_EXTR.DATA[3500,11]):"|":(Link_RESP_EXTR.DATA[3511,8]):"|":(Link_RESP_EXTR.DATA[3524,8]):"|":(ErrorCodes) in my transformer but it makes the data look like:
File partially processed|Total-10|Accepted-0|Rejected-10|AD43829T||||4,5
File partially processed|Total-10|Accepted-0|Rejected-10|AF87571S||||4,5
File partially processed|Total-10|Accepted-0|Rejected-10|CP06459X||||4,5
Is there a way to make it just a header using one column?
Thanks
[Note - had to disable Smilies in the post - Andy]
AD43829T||||4,5
AF87571S||||4,5
CP06459X||||4,5
AD99586W||||4,5
CK71846A||||4,5
In the transformer, I want to add a header to this to make the output look like this:
File partially processed|Total-10|Accepted-0|Rejected-10|
AD43829T||||4,5
AF87571S||||4,5
CP06459X||||4,5
AD99586W||||4,5
CK71846A||||4,5
But only using 1 column. Is this possible? I used the code:
(("File partially processed"):"|":("Total":"-":Detail_Count):"|":("Accepted":"-":(Detail_Count - Reject_Count)):"|":("Rejected":"-":Reject_Count)):"|":(Link_RESP_EXTR.DATA [71,8]):"|":(Link_RESP_EXTR.DATA[3500,11]):"|":(Link_RESP_EXTR.DATA[3511,8]):"|":(Link_RESP_EXTR.DATA[3524,8]):"|":(ErrorCodes) in my transformer but it makes the data look like:
File partially processed|Total-10|Accepted-0|Rejected-10|AD43829T||||4,5
File partially processed|Total-10|Accepted-0|Rejected-10|AF87571S||||4,5
File partially processed|Total-10|Accepted-0|Rejected-10|CP06459X||||4,5
Is there a way to make it just a header using one column?
Thanks
[Note - had to disable Smilies in the post - Andy]