Select to view content in your preferred language

Setting Null Value based on other Cell [Hosted Feature Layer]

226
1
Jump to solution
a month ago
Labels (1)
McMP268
New Contributor II

Hi,

Summary:
Looking to reset a specific table cell to Null as it's currently showing as Blank (due to deleting previous data within that cell)

Context:
Working with a ArcGIS Online Hosted Feature Layer, which is being updated by Surveys.
I've made a dashboard to display the results, however when I ran a test on two of the surveys that update fields I filled out a response which skewed the pie charts based on Responses.

Initially the data was showing as below (example):

CompanyID

RespondentA

ResponseA

RespondentB

ResponseB

ABC123

TestUser

Accept

TestUser

Accept

ABC234

TestUser

Reject

TestUser

Reject

ABC345

User1

Accept

User2

Accept

ABC456

User1

Reject

User2

Reject

ABC567

<null>

<null>

<null>

<null>

ABC678

<null>

<null>

<null>

<null>


Where ABC123 and ABC234 were the test data. With the pie chart showing 2 Accept, 2 Reject and 2 Null values per Response (A or B)

However, having deleted the data from the fields for ABC123 and ABC234 the table now looks like:

CompanyID

RespondentA

ResponseA

RespondentB

ResponseB

ABC123

 

 

 

 

ABC234

 

 

 

 

ABC345

User1

Accept

User2

Accept

ABC456

User1

Reject

User2

Reject

ABC567

<null>

<null>

<null>

<null>

ABC678

<null>

<null>

<null>

<null>


This now displays as 2 Blank, 1 Accept, 1 Reject and 2 Null on the pie chart.

Is there a way to reset the specific Respondent A/B or Response A/B cells to <null> by CompanyID, specifically for ABC123 or ABC234 without resetting all cells in the Respondent A/B or Response A/B columns?

e.g. Where CompanyID is ABC123 set ResponseA is None (<null>)

Thanks in advance.

0 Kudos
1 Solution

Accepted Solutions
McMP268
New Contributor II

Found solution, within the Feature Layer data table.


Just needed to add a full stop/period "." to the blank cell. then delete the full stop, then cell reverted to <null>

View solution in original post

0 Kudos
1 Reply
McMP268
New Contributor II

Found solution, within the Feature Layer data table.


Just needed to add a full stop/period "." to the blank cell. then delete the full stop, then cell reverted to <null>

0 Kudos