Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

joining to an already created table

Hi - rookie user here ...

I have spreadsheets that are all tied together with a hostname.

LOAD hostname,
group
,'1'
FROM

(
ooxml, embedded labels, table is VZSolaris);

noconcatenate
LOAD hostname,
group
,'2'
FROM

(
ooxml, embedded labels, table is fNTECLinux);

etc ...

After I "tie" all of the sheets together, I created a 'table box' which gives me a nice start for what I'm looking for.

Ideally, is there a way I could tie all of those spreadsheets together into the form of a table (basically create the table box as a data table), THEN, add some more logic to left join the newly created table against another table.

Thanks.

Joanne

1 Solution

Accepted Solutions
jonathandienst
Partner - Champion III
Partner - Champion III

Deployments:
load hostname
,
applymap('deploy1', hostname, 'NoNum') as DeployDesc1
,
applymap('deploy2', hostname, 'NoNum') as DeployDesc2
FROM

(
ooxml, embedded labels, table is
LookAtMe);

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

8 Replies
dineshkumar
Contributor III
Contributor III

Hi joan,

     there is a function called applymap() try using it. Applymap() will locate your tables and write the data you want.

avinashelite

Did not get your exact requirement, you can try to create a master table which include all the table based on the you can join the other tables according to your requirement

dineshkumar
Contributor III
Contributor III

//following will be mapping table ,wont get in the memory of qlikview//

//qlik will link this column to next table and writes below column //

mapping LOAD [prod number] ,

     [prod name]

FROM.................

//actual table that will be loaded//

LOAD desc,

     [prod number],

     age,

     address,

     ApplyMap('dinesh',[prod number],null()) as prs_name

FROM...................

Not applicable
Author

Hi .. I'm doing something wrong ...

deploy1:
mapping LOAD hostname
,
filesource1 as FILESOURCE1
FROM

(
ooxml, embedded labels, table is VZSolaris);


deploy2:
mapping LOAD hostname
,
filesource2 as FILESOURCE2
FROM

(
ooxml, embedded labels, table is fNTECLinux);



Deployments:
load hostname
,
applymap('deploy1',FILESOURCE1,'NoNum') as DeployDesc1
,
applymap('deploy2',FILESOURCE2,'NoNum') as DeployDesc2
FROM

(
ooxml, embedded labels, table is LookAtMe);

I'm getting a FILESOURCE1 and FILESOURCE2 field not found message and those fields do exist.

dineshkumar
Contributor III
Contributor III

Hi joan,

     it is case sensitive , you have to take only the original name (filesource1,filesource2). You cant use the alias name in the same edit script.

jonathandienst
Partner - Champion III
Partner - Champion III

Deployments:
load hostname
,
applymap('deploy1', hostname, 'NoNum') as DeployDesc1
,
applymap('deploy2', hostname, 'NoNum') as DeployDesc2
FROM

(
ooxml, embedded labels, table is
LookAtMe);

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
dineshkumar
Contributor III
Contributor III

its right joan

Not applicable
Author

perfect answer .. the field was messing me up - thanks!