topic Re: Null entry filed values need to be capture in a table in App Development

Null entry filed values need to be capture in a table

harish_meda — Mon, 29 Mar 2021 10:35:36 GMT

Hi All,

I want to display the SessiosnID value status in a table

Session Table:

Incient :Table

TicketNumber

123

456

689

Result:

QFabian — Mon, 29 Mar 2021 12:31:26 GMT

Hi @harish_meda , please try this :

Session2:
LOad
*,
if(isnull(SessionID) or SessionID='', 'No', 'Available') as Status
Resident Session;
drop table Session;

harish_meda — Mon, 29 Mar 2021 15:44:22 GMT

Hi,

Thanks for the solution.The above logic is giving status only Available.But your logic helps me think in another way.

But I have tried apply map it is working.

map:

Mapping load
Incident Number,
SessionID Resident Session Details;

Main:

IncidnetNumber,

applymap('map',IncidentNumber,'NotAvailable') as SessionAvailableStatus

Resident Incidents:

QFabian — Mon, 29 Mar 2021 15:48:59 GMT

perfect @harish_meda , i thought abou mapping, but just lookeed to Incient Table , and with just one field, mapp doesnt work

Good Job!