CSV header trailer

[Krish]

Hi All,

Please note that I have following data as result of module.(from union & sort tool)

001_PKEY	002_SKEY	003_TYPE	004_Condn
abcKey	581	100	Closed
abcKey	581	200	t
abcKey	581	300
abcKey	581	300	t
abcKey	581	999
123Key	628	100	Closed
123Key	628	300
123Key	628	300
123Key	628	300
123Key	628	999

I am able to create files per PKEY using file name like LoadFile_001_Pkey in Output tool.

Now I need to add header and trailer as follows.

1LoadString 20170831 PKEYValue 6<EndOfLine>

abcKey,581,100,Closed
abcKey,581,200,t
abcKey,581,300
abcKey,581,300,t
abcKey,581,999

3<CountofRecords(5)>  6<endofline>

Similarly for the other one 123Key .

Could you please advice how to generate the final rows?

I tried union options and manual configure but could not get correct results.

Thanks in advance.

Regards,

Krishna

[gnans19 · Accepted solution]

I would concat all columns comma separated using formula tool and perform union. The final output would be a single column data stream.