Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
in this below script my DESG and PH.NO fields contains null values. but i cant get that fields name by using the below IF condition. Please help me on this .
test:
LOAD [Emp No],
[Emp Name],
Desg,
Address,
Ph.No,
If(IsNull([Emp No]),'[Emp No]' , If(IsNull([Emp Name]),'[Emp Name]' , If(isnull(Address),'Address' , If(isnull(Ph.No),'Ph.No' , If(isnull(Desg),'Desg'))))) as NullFields
FROM
[alert testing data.xlsx]
(ooxml, embedded labels, table is Sheet1);
thnx
But jagan i cant do this for 247 fields right
please find the attached sample data.
in that sample data my desg and ph. no is null so i need find the column name and need to list it as a field.
it will chage day by day tommorow it may be my emp. name and ph.no
thnx
Hi,
Have a look at the attached example.
Hope this will clear your idea.
Regards,
Kaushik Solanki
hi Kaushik,
Yes.. this is what i want . thanks