topic Re: Script in QlikView

Script

Pujitha — Wed, 17 Jul 2019 16:25:56 GMT

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.

Re: Script

lockematthewp — Wed, 17 Jul 2019 16:36:46 GMT

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)

Re: Script

Pujitha — Thu, 18 Jul 2019 16:24:20 GMT

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