Create a Fixed Width File

Matillion ETL
1

I have a requirement to create Fixed Width files for delivery to external Partners. Sourcing data from Snowflake. Does anyone have suggestions/experience they can share on easiest/best way to do this?

 

Thanks.

2

Hi @BillBrink​,

Snowflake does not seem to have a fixed width file format, so I think you will need to create an export table (or view) with the columns manually set to the required width. You could use RPAD in a Calculator component for that purpose.

Best regards,

Ian