Write(load) data into flat file.

[mohan_salla]

Dear Experts,
I have to load the data into a flat file and atleast leave first 4 rows blank(I meant say that Data should be written

into file from 5th row onwards in flat file).See below screenshot.

Could anybody advise me asap.

Thanks&Regards
Mohan

[Former Member · Accepted solution]

Hi Mohan,

I suggest to split your workflow in two steps. First you connect the object "Row_Generation" with a query to your flatfile. Set the amount of rows to 4. It will generate 4 lines with an ID field.

In the output schema of your query you can fill the fields with NULL or blank as needed.

In the second step you export your data as usual.

Regards

Jürgen

[mohan_salla · Accepted solution]

Thank you for your kind advise and appreciated for your help.

This is not working as I expected.

Suppose source data table has 100 rows and I want to export it to .txt file. I am expecting to see 4 blank rows + 5th row should be column headers and 100 rows.

Could you please send me atl if possible,

Kind regards

Mohan

[Former Member · Accepted solution]

Hi,

Not tried, but should work i guess. There is an option in the file format editor 'Skip rows'. You can enter a value there to skip rows.

Have you tried that?

The easiest option would be to insert a post load command with SQL query in a template table and convert template table to text file.

Thanks,

Arun

[mohan_salla · Accepted solution]

Hi Jürgen,

I tried as you advised but it's keep on over writting first 4 rows and start loading from 1st row and never loaded the data after 4 rows as expected.I have changed flatfile properies skip rows etc..but no use. Please could you please advise me.

thanks

mohan