topic Re: load same table in QlikView

load same table

Fuel666 — Tue, 18 Jan 2022 16:07:19 GMT

Hello,
is it possible to load the same table in the same script without creating a synthetic key because the fields are the same?
I would like to create two separate tables from the same upload file

Tab1:

LOAD

A,
B,
if(Trim(A) = '' and trim(B) = '' , 'Y', 'N') as C

FROM
[C:\Table1.qvd]
(qvd)

Tab2:

LOAD

A,
B,

if(Trim(A) <> '' and trim(B) = '' , 'Y', 'N') as D

FROM
[C:\QLIK\Table1.qvd]
(qvd)

Thank '

Best

Re: load same table

anat — Fri, 21 Jan 2022 10:20:23 GMT

use concatenate function to avoid synthetic table.

Tab1:

LOAD

A,
B,
if(Trim(A) = '' and trim(B) = '' , 'Y', 'N') as C

FROM
[C:\Table1.qvd]
(qvd)

concatenate

Tab2:

LOAD

A,
B,

if(Trim(A) <> '' and trim(B) = '' , 'Y', 'N') as D

FROM
[C:\QLIK\Table1.qvd]
(qvd)

Re: load same table

Fuel666 — Fri, 21 Jan 2022 10:40:49 GMT

Hi,

thanks but with concatenate I get a single table while I want two distinct Tab1 and Tab2

Re: load same table

jmartineze — Fri, 21 Jan 2022 11:05:38 GMT

Hi, you can use unqualify statement.

also you can use loosen table Table 2;

Re: load same table

Fuel666 — Fri, 21 Jan 2022 11:17:12 GMT

Hi ,

where I insert unqualify in the script posted above

Thank you

Re: load same table

jmartineze — Fri, 21 Jan 2022 11:21:13 GMT

first line

Re: load same table

Fuel666 — Fri, 21 Jan 2022 11:32:19 GMT

I tried but the synthetic table is always created
with unqualify in the first line

Re: load same table

jmartineze — Fri, 21 Jan 2022 11:37:03 GMT

sorrry,

is qualify *;

Re: load same table

Fuel666 — Fri, 21 Jan 2022 11:46:50 GMT

Yes!

Thank you