Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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