topic Re: load comma and space separated fields in QlikView

load comma and space separated fields

Anonymous — Thu, 13 Feb 2014 01:10:50 GMT

Data is in text file. I converted into csv and fields are separated by commas and some are with spaces.

how can i extract data as correct fields, which has combination of comma and space separated fields?

Re: load comma and space separated fields

iktrayanov — Thu, 13 Feb 2014 01:19:13 GMT

Can you share a sample of your data?

Re: load comma and space separated fields

Anonymous — Thu, 13 Feb 2014 03:21:40 GMT

here is the file.. open in note pad .. convert into csv..

Re: Re: load comma and space separated fields

Thu, 13 Feb 2014 03:52:10 GMT

Hi Praveena, First you need to load file with any delimiter and then creates the fields with subfield function.

Please find the attached file for reference.

Re: load comma and space separated fields

Anonymous — Thu, 13 Feb 2014 17:35:38 GMT

Hi Dathu,

Thanks but you see irregularity of data representing in fields on 6th row from last . That's data structure problem.. I guess we cant fix it until data is in proper format because we can able to look data and may fix in one file here but not in all..

Re: load comma and space separated fields

Thu, 13 Feb 2014 18:06:01 GMT

First Solution would be an extension to Dathu's solution... Write a loop to check for space or ',' using subfield to write values to each column

Second one is to clean up your data. if you have etl tools in development process that should take care of it. else you might have to do it manually.

Re: load comma and space separated fields

Fri, 14 Feb 2014 00:11:08 GMT

If you get the all the files and look into into files. After that you can write what you need and what is the o/p.