Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Mahesh,
I don't understand what you are looking for?
HI,
Where ever 11 is having NUMBER field i want "REC" in "NAME field.
load
ID,
if (NUMBER=11,'REC',NAME) as NAME,
NUMBER
from
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;
Load
ID,
IF(NUMBER = 11, 'REC', NAME) as NAME,
NUMBER
From YourTable;
If (match(Number,'11'),'REC',NAME) as Name
LOAD
ID as [ID],
if(NUMBER=11,'REC',NAME) as [NAME],
NUMBER as [NUMBER]
FROM (yourfile)
try this
If(Match(Number,'11'),'Rec',Name) as New
Hi,
Thanks Every one,