If condition

[qlikview979]

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.

[#2]

Hi Mahesh,

I don't understand what you are looking for?

[qlikview979]

HI,

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

[Anonymous · Accepted solution]

load

ID,

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

NUMBER

from

[trdandamudi]

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;

[MK_QSL]

Load

     ID,

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

     NUMBER

From YourTable;

[Kushal_Chawda]

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

[#8]

LOAD

     ID                                             as [ID],

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

     NUMBER                                   as [NUMBER]

FROM (yourfile)

[Chanty4u]

try this

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

[qlikview979]

Hi,

Thanks Every one,