Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

split field

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

8 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

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.

swuehl
MVP
MVP

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?

Not applicable
Author

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..

Not applicable
Author

There is also one field:

documentType

=========

Invoice

Shipment

==========

thanth group the documents...

jvitantonio
Luminary Alumni
Luminary Alumni

Ok, the same as before but use

.

.

.

WHERE documentType = 'Invoice'

and

WHERE documentType = 'Shipment'

for the second table.

Not applicable
Author

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"

jvitantonio
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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...