Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Fuel666
Contributor
Contributor

load same table

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

 

 

8 Replies
anat
Master
Master

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
Contributor
Contributor
Author

Hi,

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

Hi, you can use unqualify statement.

also you can use loosen table Table 2;

Fuel666
Contributor
Contributor
Author

Hi ,

where I insert unqualify in the script posted above

 Thank you

jmartineze
Partner - Creator
Partner - Creator

first line

Fuel666
Contributor
Contributor
Author

I tried but the synthetic table is always created
with unqualify in the first line
jmartineze
Partner - Creator
Partner - Creator

sorrry,

is qualify *;

Fuel666
Contributor
Contributor
Author

Yes!

Thank you