topic Split the data and combine in QlikView

Split the data and combine

Fri, 16 Dec 2011 15:09:56 GMT

Hello,

I've a field DateData with data like this:

DateData

2011-11-29T05:36::45.9810000

2011-11-29T05:36::45.6490000

2011-11-29T05:36::45.3140000

- So i want to generate the out for another dummy field like this

DummyDateData

2011_1129_053645_981

2011_1129_053645_649

2011_1129_053645_314

Can anyone help me on this...

Re: Split the data and combine

isaiah82 — Fri, 16 Dec 2011 15:46:57 GMT

Here's a sample QVW where I did this using two different methods.

1) I converted your string into a timestamp with the appropriate format code

2) I treated it as a character string and substringed it out

Which method is better just depends on your specific scenario. Both of these assume that your input values are always the same length; e.g. contains 0's as fillers, so May would be in there as "05" instead of just "5".

Hope this helps -Isaiah

Split the data and combine

Fri, 16 Dec 2011 16:27:45 GMT

it is working in your file but it is not working in my file. I'm using qvd file

TIMESTAMP(TIMESTAMP#(LEFT(REPLACE(LensInspectionTsA,'T',' '),24),'YYYY-MM-DD hh:mm::ss.fff'),'YYYY_MMDD_hhmmss_fff') as LensInspectionTsA1

the above code is not working.But the below code is working upto timestamp. But what format i want it is not displaying

TIMESTAMP#(LEFT(REPLACE(LensInspectionTsA,'T',' '),24),'YYYY-MM-DD hh:mm::ss.fff') as LensInspectionTsA1

Split the data and combine

isaiah82 — Fri, 16 Dec 2011 16:36:08 GMT

So the question is, what's different between my inline data and your QVD. Sounds like the filed in your QVD is already stored as a timestamp possibly? You can try wrapping the fieldname in Text() and see if that works (if so another solution may be better.) Otherwise post a sample QVD (strip out whatever you need to) and I'll have a look. -Isaiah

Re: Split the data and combine

Fri, 16 Dec 2011 17:06:14 GMT

Here i'm attaching my qvd file in zip file format..Can you please work on this data.

Re: Split the data and combine

isaiah82 — Fri, 16 Dec 2011 17:13:42 GMT

I can't open your file ~ can you repost as a regular zip or uncompressed? -Isaiah

Re: Split the data and combine

Fri, 16 Dec 2011 17:18:42 GMT

Ya i got the solution for this..

TIMESTAMP(LEFT(REPLACE(LensInspectionTsA,'T',' '),24),'YYYY_MMDD_hhmmss_fff') as DummyData