topic Re: Comparing two coloums in QlikView

Comparing two coloums

jyothish8807 — Mon, 28 Jan 2013 09:40:41 GMT

hi..

i want to compare two columns in a staright table and give an output as "YES" if both the strings in the column are matched and "NO" if not matched.

when iam using if(col1=col2,'yes','no') col1's all data is compared with 1st element of col2 and again all data of col1 is compared with col2 data.How can i avoid this???

Re: Comparing two coloums

Mon, 28 Jan 2013 09:45:58 GMT

use recno() or rowno() functions

in your script

LOAD id,

b, RowNo() as r

FROM

(ooxml, embedded labels, table is Sheet1);

then instraigh table --

if(a=b,'yes','no')

Re: Comparing two coloums

kumarnatarajan — Mon, 28 Jan 2013 09:56:34 GMT

Hi,

Please find the attached file,

Ex:

if(Column(1)=Column(2),'Yes','No')

Re: Comparing two coloums

jyothish8807 — Mon, 28 Jan 2013 10:06:30 GMT

Can u plz explain me how to use rowno() properly.

i want to compare tag1 and tag2 and both columns are from different sheet.

Re: Comparing two coloums

Mon, 28 Jan 2013 10:06:57 GMT

Hi,

Using,

if(col1=col2,'yes','no')

I am getting the required output as "Yes" or "No" at my end.

Regards,

Snehal Nabar

Re: Comparing two coloums

alexandros17 — Mon, 28 Jan 2013 10:09:22 GMT

Here is an example, hope it helps.

Re: Comparing two coloums

jyothish8807 — Mon, 28 Jan 2013 10:30:05 GMT

iam taking two coloumns from two different sheets in that case all data of ist column is compared with first element of 2nd column. which i dont want. i want to solve this issue.

Re: Comparing two coloums

jyothish8807 — Mon, 28 Jan 2013 10:40:57 GMT

Thanxxxxxx

Re: Comparing two coloums

alexandros17 — Mon, 28 Jan 2013 10:43:00 GMT

So You have two different tables each one with a column and you want to compare the columns.

This is not possible until you link the tables togheter, send me the source tables, I'll try to help.

Bye

Alessandro

Re: Comparing two coloums

Mon, 28 Jan 2013 11:36:07 GMT

sorry for late reply.

rowno()

Returns the number of the current row within the current column segment in a table or, in the case of bitmap charts, within the chart's straight table equivalent. The first row is number 1.

in your script after field name we write rowno() function then it count first row as 1.

please see the attachement.