ACS - Load file with fixed width columns

Avatar

Avatar
Validate 1
Level 3
jonasn92134656
Level 3

Likes

28 likes

Total Posts

38 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
jonasn92134656
Level 3

Likes

28 likes

Total Posts

38 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
jonasn92134656
Level 3

09-11-2018

Hi,

The documentation and the interface indicates that it is possible to import files with fixed columns widths. How is that actually set up in the interface? Fixed width files columns are not detected automatically. Selecting "fixed width" under file structure/configuration doesn't seem to do anything. The column definition settings doesn't seem to have any settings related to fixed width either.

How can I go about to import fixed column width files?

Regards,

Jonas

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Level 3
jonasn92134656
Level 3

Likes

28 likes

Total Posts

38 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Validate 1
Level 3
jonasn92134656
Level 3

Likes

28 likes

Total Posts

38 posts

Correct reply

8 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 25
Boost 10
View profile
jonasn92134656
Level 3

14-11-2018

Solved this. Add columns under column definition, use "Maximum number of characters" to indicate individual field length. Fields are arranged from top to bottom.

Regards,

Jonas

Answers (0)