topic Re: joining to an already created table in QlikView

joining to an already created table

Thu, 15 Oct 2015 12:13:59 GMT

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

Re: joining to an already created table

dineshkumar — Fri, 16 Oct 2015 07:48:11 GMT

Hi joan,

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

Re: joining to an already created table

avinashelite — Fri, 16 Oct 2015 07:51:08 GMT

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

Re: joining to an already created table

dineshkumar — Fri, 16 Oct 2015 07:54:01 GMT

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

Re: joining to an already created table

Fri, 16 Oct 2015 13:09:45 GMT

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.

Re: joining to an already created table

dineshkumar — Mon, 19 Oct 2015 05:53:51 GMT

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.

Re: joining to an already created table

jonathandienst — Mon, 19 Oct 2015 05:58:36 GMT

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

(ooxml, embedded labels, table is LookAtMe);

Re: joining to an already created table

dineshkumar — Mon, 19 Oct 2015 07:12:13 GMT

its right joan

Re: joining to an already created table

Mon, 19 Oct 2015 17:45:35 GMT

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