community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Import text into columns with variable layouts

 

Good afternoon friends.

I have a very large database (txt) that has different column layouts according to the header at the beginning of each row. I have not yet found a way to import correctly, separate tables for each header, and the correct column division for each layout.
Anyone have any tips?

 


I'm trying to extract a piece of the base but I have not yet succeeded.

 

Tks

Alessandro Bruno

Bolide

Can you post some sample input and desired output?

Hi ChrisTX

 

I attached a file that gives an idea of ​​what I need.

 

The first line starts with 0, which is a layout of the file's date information.

 

The second line starts with the 1 that refers to a company registration layout.

 

The next 37 lines, starting with 2, are the company's contact record.

 

Finally line 40, starts with the number 6 is an additional information to the company register.

 

I need to bring this to different tables because each group has a different layout.

 

Thanks for your time.

Bolide

Try this approach:

 

https://3danim8.wordpress.com/2015/08/30/alteryx-devours-another-real-world-problem/

 

Splitting a flat-file that contains variable record structures
Process a fixed file layout with various multiple record formats within one file

 

Step 1: Splitting a flat-file that contains variable record structures
video: https://videos.files.wordpress.com/qiZNIMpA/part-1-splitting_flat_files_with_variable_record_designs...


Step 2: Setting up a flat-file configuration file
https://videos.files.wordpress.com/qqdC0Tg4/part-2-reading-flat-files-that-have-implicit-decimal-dig...

 

full list of videos:

 

The Alterxy Techniques
Here are the Alteryx techniques discussed in the seven videos in this article:

 

Splitting a flat-file that contains variable record structures
Setting up a flat-file configuration file
Using the RecordID tool to help quickly interrogate data
Using the auto field tool to help keep the data compact
Operating on unsigned numeric fields that have implicit decimal digits
Creating dates from a flat-file when the dates are incomplete
Converting time-variable currencies from many countries into US dollars

 

Labels