I have data in 2 txt files in which I am trying to have Talend sort through a file of data according to the position of data and then filter the Variable names into being columns in an output file.
For example
File 1
Position Variable
1- 2 FIPS State code (00 for US record) 4- 6 FIPS county code ( 0 for US or state level records)
8- 15 Estimate of people of all ages in poverty 17- 24 90% confidence interval lower bound of estimate of people of all ages in poverty
File 2
42
9
5864
4819
42
11
47405
42354
In which the position from file 1 corresponds to the number each digit represents in file 2.
