topic SQL issue in QlikView

SQL issue

patrou38 — Tue, 27 Feb 2018 12:40:08 GMT

Hello I'm trying to do a select from a data based. no issue with this.

My problem is that I have a field1 with some data which could be like :

Field1:

data1 / data2

data4

data5

data6

Data7/data8

Field2:

input

input ...

I would like to put de data in the field one in with 1 data by row and for sure this is not the case when I do something like this:

SQL select * from table. for sure I've to apply a trick but I don't know which one 😞

how can separate data1/data2 and data7/data8 ?

thank you for your help.

Best regards,

Patrick

Re: SQL issue

YoussefBelloum — Tue, 27 Feb 2018 12:50:16 GMT

Hi,

what do you mean by:

I would like to put de data in the field one in with 1 data by row ?

Re: SQL issue

patrou38 — Tue, 27 Feb 2018 12:57:55 GMT

in fact I would like to retrieve in my data in a single column with 1 data by row .

after this this data will be a Key between tables in my data model

Re: SQL issue

fvelascog72 — Tue, 27 Feb 2018 12:58:39 GMT

Hi,

Try with:

SubField(PurgeChar(Field1, ' '), '/')

Saludos

Re: SQL issue

YoussefBelloum — Tue, 27 Feb 2018 13:04:36 GMT

the solution of Frederico below will work then

Re: SQL issue

patrou38 — Tue, 27 Feb 2018 13:04:40 GMT

sorry but I don't see how I can put it in my SQL select .....

and beside this it will remove the separator but I will have 2 data in the same row (even if there is no more separator), no ?

Re: SQL issue

stigchel — Tue, 27 Feb 2018 13:19:20 GMT

Use a preceding load, the subfield will create a row for each subfield value

Load SubField(PurgeChar(Field1, ' '), '/') as Field1,Field2;

SQL Select Field1, Field2

From Table;

Re: SQL issue

patrou38 — Wed, 28 Feb 2018 08:14:02 GMT

Hello Piet,

thank you for your answer. this works properly to remove the concerned character 🙂

last blocking point, how can I load all fields from the table including the filter you suggested to me ?

when I try why the script below it doesn't work 😞

Load Subfield(PurgeChar(fields1,''),',');
SQL select distinct *
FROM table1;

thank you in advance .

Regards,

Patrick

Re: SQL issue

fvelascog72 — Wed, 28 Feb 2018 09:19:22 GMT

Hi,

Maybe be:

Load

Subfield(PurgeChar(fields1,''),',')

;
SQL select distinct *
FROM table1;

Saludos

Re: SQL issue

patrou38 — Wed, 28 Feb 2018 10:21:25 GMT

great, it woarks .

thank you for all