topic How to Split the string into number of sub strings in QlikView

How to Split the string into number of sub strings

Mon, 24 Oct 2011 07:14:20 GMT

Hi,

I am creating one QVW file in my project by taking the QVD file as a data source. In this QVD one of the field called HeaderDateKey has the data like,

C:\Project\QlikView\CAR\QVD\INPACT\CAR.QVD_2011-09-27.

But I would like to display the output as three fields like, ApplicationName QVDName LoadDate

CAR CAR.QVD 2011-09-27

How can we spilt the data and show in number of subfields.

It would be the greate help.

Thanks in advance................

Regards,

Praveen

Re: How to Split the string into number of sub strings

Miguel_Angel_Baeyens — Mon, 24 Oct 2011 07:24:39 GMT

Hi Praveen,

Since you are building the QVW file, you can create the name of the QVD to fit easiest your needs, but as it is now, using a few string functions will do

LOAD SubField(FileName(), '.', 1) AS ApplicationName,
     SubField(FileName(), '_', 1) AS QVDName,
     Date(Date#(SubField(FileName(), '_', 2), 'YYYY-MM-DD')) AS LoadDate,
...

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica