Null entry filed values need to be capture in a table

[harish_meda]

Hi All,

I want to display the SessiosnID value status in a table

Session Table:

	Session:
Ticket Number	Session ID
123	11
123	12
456	13
689

Incient :Table

TicketNumber

123

456

689

Result:

TicketNumber	Session Status
123	Available
456	Available
689	No

[QFabian · Accepted solution]

Hi @harish_meda , please try this :

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

[harish_meda]

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]

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

Good Job!