topic Re: If condition in QlikView

If condition

qlikview979 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I Have Source files like this

ID	NAME	NUMBER
1	AB	11
2	BC	81
3	CD	74
4	EF	16
5	GH	12

here NUMBER is 11 i want 'REC' in NAME column.

Re: If condition

Wed, 11 May 2016 12:03:39 GMT

Hi Mahesh,

I don't understand what you are looking for?

Re: If condition

qlikview979 — Wed, 11 May 2016 12:06:04 GMT

HI,

Where ever 11 is having NUMBER field i want "REC" in "NAME field.

Re: If condition

Anonymous — Wed, 11 May 2016 12:06:29 GMT

load

ID,

if (NUMBER=11,'REC',NAME) as NAME,

NUMBER

from

Re: If condition

trdandamudi — Wed, 11 May 2016 12:10:17 GMT

May be this:

Source_Table:

Load * Inline [

ID, NAME, NUMBER

1, AB, 11

2, BC, 81

3, CD, 74

4, EF, 16

5, GH, 12

];

NoConcatenate

Final:

Load

ID,

IF(NUMBER=11,'REC',NAME) as NAME,

NUMBER

Resident Source_Table;

Drop Table Source_Table;

Re: If condition

MK_QSL — Wed, 11 May 2016 12:13:02 GMT

Load

ID,

IF(NUMBER = 11, 'REC', NAME) as NAME,

NUMBER

From YourTable;

Re: If condition

Kushal_Chawda — Wed, 11 May 2016 12:14:03 GMT

If (match(Number,'11'),'REC',NAME) as Name

Re: If condition

Wed, 11 May 2016 12:34:41 GMT

LOAD

ID as [ID],

if(NUMBER=11,'REC',NAME) as [NAME],

NUMBER as [NUMBER]

FROM (yourfile)

Re: If condition

Chanty4u — Wed, 11 May 2016 12:48:07 GMT

try this

If(Match(Number,'11'),'Rec',Name) as New

Re: If condition

qlikview979 — Wed, 11 May 2016 12:48:08 GMT

Hi,

Thanks Every one,