Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to solve this:
In one field there arae Invoices and Shipment dcuments:
---------------
Document |
---------------
I1
I2
I3
I4
..
Sh1
Sh2
Sh3
Sh4
-----------------
I need to split this field in 2 fields:
======== =============
Invoice Shipment doc
======== =============
I1 sh1
I2 sh2
I3 sh3
I4 sh4
.. ....
======== ==============
Is it posible?
many Thanks
regards
Kla
temp:
LOAD Field as Invoice FROM yourfile.xls
WHERE left(Field,1)='I'
;
temp1:
LOAD Field as Shipment FROM yourfile.xls
WHERE left(Field,2)='Sh'
;
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
INVOICETABLE:
LOAD
Document as Incoice
resident YOURTABLE where Document like 'I*';
SHIPMENTTABLE:
LOAD
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..
There is also one field:
documentType
=========
Invoice
Shipment
==========
thanth group the documents...
Ok, the same as before but use
.
.
.
WHERE documentType = 'Invoice'
and
WHERE documentType = 'Shipment'
for the second table.
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
load
Document type, DocumentNo, Cust_No ....
In other table There is the field shipment (just shipment documentNO):
load
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...