Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have data Like
F_name F_blog
FSS A
Css B
MSS C
D
E
FSSC F
like that
Out Put:
F_name F_blog
FSS A
Css B
MSS C
1 D
2 E
FSSC F
If it is null value it will display the Unique values .
Please help me
Thanks & Regards,
Ram
Hi,
One solution :
load if(len(F_name)=0,autonumber(rowno()),F_name) as F_name,F_blog inline [
F_name,F_blog
FSS,A
Css,B
MSS,C
,D
,E
FSSC,F
];
output :
Hi,
One solution :
load if(len(F_name)=0,autonumber(rowno()),F_name) as F_name,F_blog inline [
F_name,F_blog
FSS,A
Css,B
MSS,C
,D
,E
FSSC,F
];
output :
Hi Taoufiq,
Thanks for your valuable solution.
Regards,
Ram