I need to solve this:
In one field there arae Invoices and Shipment dcuments:
I need to split this field in 2 fields:
Invoice Shipment doc
Is it posible?
LOAD Field as Invoice FROM yourfile.xls
LOAD Field as Shipment FROM yourfile.xls
Then you can use the fields as you want. You can also concatenate boths tables.
Hope this helps.
You can split your field f.e. like
Document as Incoice
resident YOURTABLE where Document like 'I*';
Document as [Shipment doc]
resident YOURTABLE where Document like 'Sh*';
But this creates two tables, unlinked to each other. I assume you are having more than this one field, so you could probably use a key field to link these tables?
Thanks but I think is not the correct solution. In my sample I used the
I and Sh to distinct the documents. The documentNo. are the numbers I can't
filter the string. I need to know if there is the statement..
ok but may be I don't explain well rhat I need to solve:
In one tablthere are:
Document Type shiipment and Invoice) , Document No
Document type, DocumentNo, Cust_No ....
In other table There is the field shipment (just shipment documentNO):
DocumentNo as Shipment, Cust_No ....
Now I need to create a new field in the second table: Invoice. I need to put the table in the "same row"
you will need to join your data in same way to have the documentType, otherwise you need to do it manually if there's no patter in your invoice and shipment names. You can try joining by cust_no to the the document type. Is there any way you can attach your example? You can put some sample data if you want.
Yes I already done what you suggest but the application" goes out of data"
There are many many data.
I tried also by mapping statement.
Now, I post the sample code...