Sequential File : Header generation

[Deepakinstyle]

Hi All,

My reqirement is to generate ASCII txt files from a table.
The file should have 2 headers in it. I have 3 o/p links from a transformer to 3 Seq file stage. one for each header and the last one for actual data. All headers are hardcoded(except one where am using a date from parameter), not connected to any i/p link.

But after run, the 2 header files had as many rows as in table.
eg: now i am testing with 3 records from table. and the hardcoded value for each header has been written to file 3 times.

Please help me out how to restrict header to only one row.

Thanks,
Deepak

[chulett]

Constraint?

Code: Select all

@OUTROWNUM = 1

[Deepakinstyle]

Constraint?

Code: Select all

@OUTROWNUM = 1

...

Hi Chulett,

I have tried @OUTROWNUM = 1 option, this time 2 header records are written to sequential file. But i need only 1 record.

thanks,
Deepak

[keshav0307]

use head stage and number of records 1.

[Deepakinstyle]

use head stage and number of records 1.

Hi Keshav,

Thanks for your suggestion.
i have used options,
Allow all rows = FALSE
No Of Rows/Partition = 1

All Partitions = FALSE
No Of Partitions = 1

and it is working fine. Can you confirm are these options.

Thanks,
Deepak

[keshav0307]

if it is working fine then correct option only :D

[Deepakinstyle]

if it is working fine then correct option only :D

Thanks Keshav

[ray.wurlod]

Constraint?

Code: Select all

@OUTROWNUM = 1

Foiled by parallel execution!

Maybe

Code: Select all

@OUTROWNUM = 1 And @PARTNUM = 0