Script

[Pujitha]

Hi

I have four files to load -one file is having code in one column column like '100032' something like that and other file is having text like 'Fair'can we match these two like 100032=Fair like that in qlikview script? I need do visualization if Column=Fair then some thing. I need to pull code from one table and match with text in another table? Please let me know if it is not clear. Help me asap.

[lockematthewp]

When loading your tables, when it says:

Load ….

           100032,

          …...

Just change it to:

Load …

          100032 as 'XXX', (or whatever the column name from the other table is)

          …...

Then these columns would be connected. Then in your table, you would only need to put:

if ([XXX] = 'Fair', do whatever)

[Pujitha]

Hi,

I have 4 files which I need to concatenate to one. In one file I have like

Name   Opt  loc  Cod    id    dig      Lb     .Gop.      ....... some other columns

code     0         0         24     1    exx    .....         .....         .....

prof       1        0         43     2     xer    ....          ...            ..

stud      0        0        34      3     iop     ....        ...              ....

Another table:

loc     Cod   Lb  id  gop(as op) ..............here  and so on other columns 

diff data in Lb column

another table:

Et   loc    Cod    Lb    id 

another table:

Et st  status  Lb  id  loc

I need to append all these tables to one pls let me know this clearly from start to end how to do. Please let me know asap