Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
jontydkpi
Not applicable

Re: joining to an already created table

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
8 Replies
dineshkumar
Not applicable

Re: joining to an already created table

Hi joan,

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

avinashelite
Not applicable

Re: joining to an already created table

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
Not applicable

Re: joining to an already created table

//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

Re: joining to an already created table

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
Not applicable

Re: joining to an already created table

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.

jontydkpi
Not applicable

Re: joining to an already created table

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
Not applicable

Re: joining to an already created table

its right joan

Not applicable

Re: joining to an already created table

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