We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Need to create and import and defined field setting for flat file layout

DanAAC
7 - Meteor

Hi,

 

I am using the Flat File Layout to define fixed field width for a large text file.

I want to use the ' Use Field Settings from File' option to import my settings for the layout, but I am not familiar with it.

 

The text has a fixed length for each field (see below). Can someone help create this field settings file please?

 

Thank you!

 

4
3
1
1
1
24
2
2
2
8
8
6
12
27
70
70
29
105
105
105
100
100
4
3
2
8
24
1
24
1
8
8
1
8
1
8
8
2
1
9
9
9
3
1
9
36
2
3
9
2
9
8
2
8
48
2
2
2
2
1

1 REPLY 1
OTrieger
14 - Magnetar

@DanAAC 
Check this article, as it is explaining how to do it.
https://help.alteryx.com/2020.2/DbFileInput_FlatFileEdit.htm 

Labels
Top Solution Authors