load same table

[Fuel666]

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

[anat]

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)

[Fuel666]

Hi,

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

[jmartineze]

Hi, you can use unqualify statement.

also you can use loosen table Table 2;

[Fuel666]

Hi ,

where I insert unqualify in the script posted above

 Thank you

[jmartineze]

first line

[Fuel666]

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

[jmartineze]

sorrry,

is qualify *;

[Fuel666]

Yes!

Thank you