Hi,
I have a file(Text or Excel) which contains n number of lines. The record contains 100 characters(For Example) of data. I want to send group of characters data to different destination fields.
When I upload the file using 'Import manager' I'll have all n mumber of reocrds in the <b>'Source Preview'</b>. It means only one source table which contains only one filed. This field will contain n number of records with <b>No Delimiter</b>.Each record with 100 characters. I want send group of characters data from each record to different destination fields.
For Ex:-
Source Field: AADSHDK2343324KMNKLNN343432434KKJJKKKJKJKLK
Destinaton Fields: Field1,Field2,Field3 etc..
The above record contains 'No Delimiter'
Requirement: 1-7 charactrs has to send to 'Field1'
8-14 charactrs has to send to 'Field2' etc...
How to achieve this in 'Import Manager'. How can I perform <b>'Map Fields/Values'</b> i.e <b>'Value conversion and mapping'</b>.
With best rgds.,
Srinivas