joining to an already created table

[#1]

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

[dineshkumar]

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]

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

[#5]

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]

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 · Accepted solution]

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

(ooxml, embedded labels, table is LookAtMe);

[dineshkumar]

its right joan

[#9]

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