topic Re: split field in QlikView

split field

Fri, 23 Nov 2012 10:38:11 GMT

Hi,

I need to solve this:

In one field there arae Invoices and Shipment dcuments:

---------------

Document |

---------------

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

Re: split field

jvitantonio — Fri, 23 Nov 2012 10:55:05 GMT

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.

Re: split field

swuehl — Fri, 23 Nov 2012 10:56:04 GMT

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?

Re: split field

Fri, 23 Nov 2012 10:59:32 GMT

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

Re: split field

Fri, 23 Nov 2012 11:18:12 GMT

There is also one field:

documentType

=========

Invoice

Shipment

==========

thanth group the documents...

Re: split field

jvitantonio — Fri, 23 Nov 2012 11:21:12 GMT

Ok, the same as before but use

WHERE documentType = 'Invoice'

and

WHERE documentType = 'Shipment'

for the second table.

Re: split field

Fri, 23 Nov 2012 11:32:26 GMT

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"

Re: split field

jvitantonio — Fri, 23 Nov 2012 13:34:16 GMT

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.

Re: split field

Fri, 23 Nov 2012 13:44:50 GMT

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