Coulmn name in file
Moderators: chulett, rschirm, roy
Coulmn name in file
Hi all,
I need to populate the column name if the it has values .else no values has present then empty file should be created. By setting the option in sequential file for column names first= true doesnot help me as if there are no values,only column name is generated. Could any body help me how to achieved this by derivations.
I need to populate the column name if the it has values .else no values has present then empty file should be created. By setting the option in sequential file for column names first= true doesnot help me as if there are no values,only column name is generated. Could any body help me how to achieved this by derivations.
thanks n regards
nani
nani
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
One more way you can achieve that is.
in properties set column names 'yes', it will give you column names in the output file.
In after job subroutine.
If wc -l output <= 1 then touch output_file.
that will create empty file if there is only one record with the columns.
hope this helps..
----------------
MK
in properties set column names 'yes', it will give you column names in the output file.
In after job subroutine.
If wc -l output <= 1 then touch output_file.
that will create empty file if there is only one record with the columns.
hope this helps..
----------------
MK