Dear @osmanburcu
if I understand your message is for me to limit import in to 3 or 4 batches then append them after importing,
what I did previously id import the data directly using one file name “Data” and replicate it into 51 queries do to some of the question is multiple selection which I cannot split and unpivot them because is increasing the main data, below is the screenshot of the main data which i cycle it and replicated data, also I have cycle the number of queries
Yes this is what i exactly said, You don’t need to do this duplication to all forms, just do it to the one you can’t refresh
Dear @osmanburcu
But you know I duplicate all of them and when refreshing I’m getting error in all of them, I have to do new designed by using the limitation you suggested
I suggest you using the API V2 if you would like to do a new design, what i could suggest you is, you can create a new data set, where you use the limitation and merge them as one data, later you can use this table as a reference to other tables and the rest should be done by power bi automatically
Dear @osmanburcu @Kal_Lam
I have successfully downloaded the data in different batches like is show in this message I reply
but is skips some of my field e.g. “section_2_general_protection/no_family_members_loc” is completely missing and if I check the main data in kobo I can see the field, kindly help. Thanks
Dear @baana2005,
As i mention in the previous message, i can’t comment anymore because i told everything possible. If you are willing to share the Power BI pbix file and kobo user name and password, please drop it to me a private message and let me review and come back to you.
As you can see from the previous messages, i couldn’t predict how many columns, how many submissions, how big data you have, the structure of the data. It is much easier for me to spot the mistake if i see the data.
Hi
@baana2005, I checked the Power BI and i can find the column you mentioned in the dataset, would you be missing it by mistake?
Dear @osmanburcu
The first file in the folder was before I used the new data which you help me separate it in to three batches, I have upload the new file with name" Protection Monitoring Interactive Dashboard v2 (1).pbix" the new data which remove the field mention above
Delete the last expended column1 step, because while you are importing the data you did not click the load more button probably,
After you delete the step, click the double arrow, and click the load more sentence, after it loads all the columns just click the OK to proceed. Your column should appear in the data set.
Dear @osmanburcu
Wow, Thank you for fixing my issue.
if you are creating your dashboard again, I highly suggest you to use API v2 and you can directly import it as Excel file, so i believe you will not need to import your data as three separated file and will not need to replace your values, it will decrease your work load as well as the duration of the updates. Please check the video below, it might give you some idea and if you need help, let me know
Dear @osmanburcu ,
I this my JSON data export which your previously help me fixed the missing columns has started again, now if I reload it one or more columns disappear and it’s changes from this column to another column after reloading,
hi @baana2005, can you share you advance editor codes with me? it would be easier for me to review
Dear @osmanburcu ,
Which one is advance editor code?
To to Power Query and Home tab, you will find the advance editor button left top corner in the toolbar
Dear @osmanburcu ,
Sorry It didn’t come to my mind that your referring to Power Query Advance Editor,
Note: I deleted some of my last year data and reconnected using new codes see below
First connection links
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=0&limit=15000
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=15001&limit=30000
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=30001&limit=45000
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=45001
Second connection link (the currently connected link) (current data as of today 33070)
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=0&limit=20000
https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=20001
Advance Editor Codes for (?start=0&limit=20000
let
Source = Json.Document(Web.Contents(“https://eu.kobotoolbox.org/api/v2/assets/aEgHKW9Xs6vH2sThaGVUuB/data.json/?start=0&limit=20000”, [Headers=[Authorization=“Token f6c669ffb4d4dfd53036951d2ad9ad420134263b”]])),
results = Source[results],
#“Converted to Table” = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#“Expanded Column1” = Table.ExpandRecordColumn(#“Converted to Table”, “Column1”, {“id", “formhub/uuid”, “start”, “end”, “today”, “deviceid”, “group_general_information/effective_date”, “group_general_information/country”, “group_general_information/state”, “group_general_information/LGA”, “group_general_information/WARD”, “group_general_information/location”, “group_general_information/GPS”, “group_general_information/organisation_code”, “group_general_information/organisation_11”, “group_introduction/Code_of_person”, “group_introduction/respondent_is_major”, “group_introduction/consent”, “group_introduction/language”, “section_2_general_protection/respondent_sex”, “section_2_general_protection/respondent_age”, “section_2_general_protection/C1”, “section_2_general_protection/hoh”, “section_2_general_protection/no_hoh”, “section_2_general_protection/Age”, “section_2_general_protection/C2”, “section_2_general_protection/headed_hoh_male_above_18_no”, “section_2_general_protection/Q1_header/Number”, “section_2_general_protection/Q1_header/Disaggregation_of_members_of_your_HH_that_fit_into_age_and_sex_brackets”, “section_2_general_protection/Q1_header/Less_than_5_Years_Female”, “section_2_general_protection/Q1_header/Between_18-25_Years_Female”, “section_2_general_protection/Q1_header/Less_than_5_Years_Male”, “section_2_general_protection/Q1_header/age_group_sum”, “section_2_general_protection/Q1_header/age_group_sum_children_below_17”, “section_2_general_protection/family_members_loc”, “section_2_general_protection/sep_family_members_loc”, “section_2_general_protection/una_family_members_loc”, “section_2_general_protection/are_all_school_aged_children_going_to_school”, “section_2_general_protection/status_hh”, “section_2_general_protection/dis_country”, “section_2_general_protection/dis_state”, “section_2_general_protection/dis_lga”, “section_2_general_protection/dis_ward”, “section_2_general_protection/location_hh”, “section_2_general_protection/hh_current_settlement_type”, “section_2_general_protection/current_shelter_type_1”, “section_2_general_protection/area_origin_country”, “section_2_general_protection/area_origin_state”, “section_2_general_protection/area_origin_lga”, “section_2_general_protection/area_origin_ward”, “section_2_general_protection/location_displaced”, “section_2_general_protection/when_last_displaced”, “section_2_general_protection/How_many_times_have_you_been_displaced_in_the_last_5_years”, “section_2_general_protection/what_was_the_cause_of_your_displacement”, “section_2_general_protection/red_flag_1_system”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_ret”, “section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of_displacement_why_idp_ret”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_women_and_girls_in_the_last_3_months”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_men_and_boys_in_the_last_3_months”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_people_living_with_disabilities_in_the_last_3_months”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_location_in_particular_for_older_persons_in_the_last_3_months”, “section_2_general_protection/Can_people_move_around_freely_within_your_current_location”, “section_2_general_protection/Can_people_move_freely_out_of_your_current_location”, “section_2_general_protection/do_members_of_your_HH_possess_civil_and_legal_documentation”, “section_2_general_protection/Do_your_HH_members_possess_documents_on_housing_land_and_property”, “section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_or_legal_documentation”, “section_2_general_protection/does_any_of_your_HH_members_face_any_problems_because_of_the_lack_of_personal_documentation”, “section_2_general_protection/Has_any_member_of_your_household_experienced_any_protection_incident_rights_violation_in_your_current_location_or_location_of_origin”, “section_2_general_protection/Are_there_different_population_groups_present_in_your_location”, “section_2_general_protection/How_would_you_describe_the_relationship_between_displaced_populations_and_HCs_in_your_location”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_informed_about_the_different_services_that_are_provided_by_humanitarian_organizations_for_the_population_in_need_in_your_location”, “section_3_accountability_to_AAP_community_engagement/How_well_does_your_HH_feel_informed_about_the_different_services_that_are_provided_by_humanitarian_organizations_for_the_population_in_need_in_your_location”, “section_3_accountability_to_AAP_community_engagement/Food_assistance”, “section_3_accountability_to_AAP_community_engagement/Nutrition_assistance”, “section_3_accountability_to_AAP_community_engagement/Shelter_assistance”, “section_3_accountability_to_AAP_community_engagement/NFI_assistance”, “section_3_accountability_to_AAP_community_engagement/WASH_assistance”, “section_3_accountability_to_AAP_community_engagement/Education_assistance”, “section_3_accountability_to_AAP_community_engagement/Health_assistance”, “section_3_accountability_to_AAP_community_engagement/Services_for_GBV_survivors”, “section_3_accountability_to_AAP_community_engagement/Services_for_children_in_need_of_support”, “section_3_accountability_to_AAP_community_engagement/Legal_services”, “section_3_accountability_to_AAP_community_engagement/Mental_Health_Psychosocial_support_services”, “section_3_accountability_to_AAP_community_engagement/Livelihood_services”, “section_3_accountability_to_AAP_community_engagement/What_kind_of_information_does_your_HH_want_to_receive_from_humanitarian_organizations_on_aid_or_services”, “section_3_accountability_to_AAP_community_engagement/What_would_be_your_HHs_preferred_channel_to_receive_information_about_available_aid_or_services_of_humanitarian_organizations”, “section_3_accountability_to_AAP_community_engagement/Community_leaders”, “section_3_accountability_to_AAP_community_engagement/Does_your_HH_feel_that_it_is_consulted_on_the_kind_of_aid_or_services_that_are_offered_by_humanitarian_organizations_in_your_location”, “section_3_accountability_to_AAP_community_engagement/Do_you_feel_the_kind_of_services_offered_by_humanitarian_organizations_are_responding_to_your_HHs_problems_and_meeting_the_needs_your_HH_has”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_aware_of_ways_to_complain_about_the_delivery_of_humanitarian_services_and_to_provide_feedback_for_the_improvement_of_humanitarian_services”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and_provide_feedback_to_humanitarian_organizations_are_you_aware_of”, “section_3_accountability_to_AAP_community_engagement/Has_your_HH_ever_used_any_of_these_modalities_to_provide_feedback_or_to_complain_to_aid_organizations_on_the_assistance_received”, “section_3_accountability_to_AAP_community_engagement/did_you_receive_any_feedback_assistance”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_people_in_your_community_face_when_wanting_to_utilize_any_of_the_mechanisms_to_provide_feedback_and_complain”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_that_you_are_NOT_supposed_to_pay_whether_by_cash_or_by_offering_sex_to_receive_humanitarian_aid”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_an_aid_worker_with_a_child__is_unacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_relationship_between_aid_workers_and_adults_is_unacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/An_exchange_of_good_services_for_sex_between_an_aid_worker_and_a_beneficiary_is_unacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_aid_workers_with_prostitutes_is_inacceptable”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_of_a_mechanism_to_raise_complaints_in_case_of_incidents_related_to_sexual_misconduct_from_aid_workers”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanisms_are_available_in_your_location_site”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Among_those_reporting_mechanisms_which_one_would_you_prefer”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/would_your_hh_feel_confident_complaint”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/report_sexual_misconduct_by_air_worker”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Basic_material_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Medical_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Psycho_social_support”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Legal_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Safe_shelter”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Reintegration_in_the_community”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/DNA_paternity_identification_for_children_born_from_experience_of_sexual_misconduct_of_aid_workers”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitarian_organizations_do_to_address_the_problem_of_sexual_misconduct_of_aid_workers”, “Section_5_Priority_needs_and_access_to_services/Priority_No_1”, “Section_5_Priority_needs_and_access_to_services/condition_1”, “Section_5_Priority_needs_and_access_to_services/NFIs1”, “Section_5_Priority_needs_and_access_to_services/Priority_No_2”, “Section_5_Priority_needs_and_access_to_services/condition_2”, “Section_5_Priority_needs_and_access_to_services/Food2”, “Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “Section_5_Priority_needs_and_access_to_services/condition_3”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training3”, “Section_6_Referrals/Does_the_HH_require_a_referral_to_service_providers”, “Section_6_Referrals/From_the_information_you_have_shared_I_can_see_that_y”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major”, “Section_6_Referrals/Comments_to_be_filled_out_by_the_protection_monitor_major”, “Section_6_Referrals/referral_details_nfis/referral_repeat_nfis”, “version”, “meta/instanceID”, “xform_id_string", “uuid", “attachments", “status", “geolocation", “submission_time", “tags", “notes", “validation_status", “submitted_by", “section_2_general_protection/Q1_header/Between_26-59_Years_Female”, “section_2_general_protection/headed_hoh_male_child_above_60_no”, “section_2_general_protection/Q1_header/Between_5-12_Years_Female”, “section_2_general_protection/headed_hoh_female_above_18”, “section_2_general_protection/Q1_header/Between_13-17_Years_Female”, “section_2_general_protection/Q1_header/Between_5-12_Years_Male”, “section_2_general_protection/Q1_header/Between_13-17_Years_Male”, “section_2_general_protection/Are_women_among_those_HH_members_who_possess_civil_and_legal_documentation”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members_of_your_HH_possess”, “Section_6_Referrals/Last_name”, “Section_6_Referrals/FIrst_name”, “section_2_general_protection/Q1_header/Between_18-25_Years_Male”, “section_2_general_protection/what_are_the_reasons_for_children_not_going_to_school”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_being_stopped”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_movement_being_restricted”, “Section_6_Referrals/phone_num”, “section_2_general_protection/Q1_header/Between_26-59_Years_Male”, “Section_5_Priority_needs_and_access_to_services/NFIs3”, "Section_5_Priority_needs_and_access_to_services/Priority_No_1”, "Section_5_Priority_needs_and_access_to_services/Priority_No_2”, "Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “section_2_general_protection/child_at_rist”, “section_2_general_protection/elderly_at_rist”, “section_2_general_protection/none_of_the_HH_members_is_vulnerable”, “Section_5_Priority_needs_and_access_to_services/Food1”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training2”, “Section_5_Priority_needs_and_access_to_services/Shelter1”, “Section_5_Priority_needs_and_access_to_services/NFIs2”, “section_2_general_protection/intend_move_current_location_idp_ret”, “section_2_general_protection/intend_move_preferred_destination_idp_ret”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move”, “section_2_general_protection/when_do_you_want_to_move_to_country”, “section_2_general_protection/when_do_you_want_to_move_to_state”, “section_2_general_protection/when_do_you_want_to_move_to_lga”, “section_2_general_protection/when_do_you_want_to_move_to_ward”, “section_2_general_protection/location_move_to”, “section_2_general_protection/intend_move_current_access_info”, “section_2_general_protection/info_hh_make_decision_preferred_location”, “section_2_general_protection/requirement_move_preferred_location”, “section_2_general_protection/sources_info_location_intended”, “section_2_general_protection/current_location_hh”, “section_2_general_protection/media_sources_hh”, “section_2_general_protection/Fredom_group_001/freedom_movement_questions_001”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_impacted_people_in_your_location”, “section_2_general_protection/Do_people_in_your_location_report_these_restrictions_on_their_freedom_of_movement”, “section_2_general_protection/Who_do_they_generally_report_these_restrictions_to”, “section_2_general_protection/when_people_in_your_community_reported_any_of_these_restrictions_on_their_freedom_of_movement_was_a_solution_found_to_improve_their_freedom_of_movement”, “section_3_accountability_to_AAP_community_engagement/Village_elders”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_people_in_your_community_face_when_wanting_to_utilize_any_of_the_mechanisms_to_provide_feedback_and_complain_other”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanisms_are_available_in_your_location_site_other_001”, “Section_5_Priority_needs_and_access_to_services/WASH3”, “Section_5_Priority_needs_and_access_to_services/WASH2”, “Section_5_Priority_needs_and_access_to_services/Food3”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and_provide_feedback_to_humanitarian_organizations_are_you_aware_of_other”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training1”, “section_2_general_protection/women_at_rist”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_refugee”, “section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of_displacement_why_idp_refugee”, “section_3_accountability_to_AAP_community_engagement/Religious_leaders”, “Section_5_Priority_needs_and_access_to_services/Shelter3”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_access_humanitarian_services_or_commodities_for_people_in_need_in_your_location_q1”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_cannot_access_needed_services_or_commodities_what_do_they_do_q1”, “Section_6_Referrals/referral_details_food/referral_repeat_food”, “Section_6_Referrals/referral_details_livelihood_vocational_training/referral_repeat_livelihood_vocational_training”, “Section_6_Referrals/referral_details_shelter/referral_repeat_shelter”, “Section_5_Priority_needs_and_access_to_services/Shelter2”, “Section_6_Referrals/dob”, “Section_6_Referrals/comments”, “section_2_general_protection/requirement_move_preferred_location_other_001”, “section_2_general_protection/what_are_the_reasons_for_people_in_your_location_to_feel_unsafe”, “section_2_general_protection/Attacks_against_the_population”, “section_2_general_protection/Risk_of_abduction_and_demands_for_ransom”, “section_2_general_protection/In_which_of_the_following_locations_do_all_community_members_men_boys_women_girls_often_not_feel_safe”, “section_2_general_protection/In_the_fields_when_fetching_firewood_water_scrap_metal”, “section_2_general_protection/In_the_fields_when_doing_farming”, “section_2_general_protection/Does_your_community_have_strategies_to_deal_with_the_lack_of_safety_for_community_members”, “section_2_general_protection/when_did_the_HH_member_experience_the_protection_incident”, “section_2_general_protection/type_of_incid_tookplace/type_of_incid_tookplace_questions”, “section_2_general_protection/whom_do_people_in_your_community_report_protection_incidents_to”, “section_2_general_protection/did_the_HH_members_affected_by_the_protection_incident_receive_any_relevant_support_or_services”, “Section_5_Priority_needs_and_access_to_services/Education3”, “section_2_general_protection/child_at_rist_school”, “section_2_general_protection/separated/Number_sep”, “section_2_general_protection/separated/Dissaggregation_of_children_within_your_HH_separated”, “section_2_general_protection/separated/Female5”, “section_2_general_protection/separated/Female5to12”, “section_2_general_protection/separated/Male5to12”, “section_2_general_protection/separated/number_separated_sum”, “section_2_general_protection/serious_med_cond”, “section_2_general_protection/are_women_among_those_possessing_HLP_documentation”, “section_2_general_protection/what_type_of_HLP_documents_do_your_HH_members_possess”, “section_2_general_protection/headed_hoh_male_child_above_60”, “section_2_general_protection/headed_hoh_male_above_18”, “section_2_general_protection/Q1_header/Above_60_Years_Female”, “section_2_general_protection/Q1_header/Above_60_Years_Male”, “section_2_general_protection/disabilities”, “section_2_general_protection/headed_hoh_female_child_above_60”, “section_2_general_protection/current_shelter_type_2”, “Section_5_Priority_needs_and_access_to_services/Education1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property3”, “Section_5_Priority_needs_and_access_to_services/Health3”, “Section_5_Priority_needs_and_access_to_services/Health2”, “Section_5_Priority_needs_and_access_to_services/Education2”, “section_2_general_protection/unaccompanied/Number_una”, “section_2_general_protection/unaccompanied/Dissaggregation_of_children_within_your_HH_unaccompanied”, “section_2_general_protection/unaccompanied/Male5_una”, “section_2_general_protection/unaccompanied/number_unaccompanied_sum”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitarian_organizations_do_to_address_the_problem_of_sexual_misconduct_of_aid_workers_other”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_access_humanitarian_services_or_commodities_for_people_in_need_in_your_location_other_q1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property2”, “section_2_general_protection/In_some_blocks_of_the_camp_community”, “section_2_general_protection/Proximity”, “section_2_general_protection/Presence_of__NSAGs”, “section_2_general_protection/Criminal_activities_in_the_area”, “section_2_general_protection/In_some_streets_of_the_camp_community”, “section_2_general_protection/Within_their_house_tent”, “section_2_general_protection/what_are_these_strategies”, “section_2_general_protection/Fredom_group/freedom_movement_questions”, “Section_5_Priority_needs_and_access_to_services/Health1”, “section_2_general_protection/hh_current_settlement_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women2”, “Section_5_Priority_needs_and_access_to_services/Support_to_children3”, “Section_5_Priority_needs_and_access_to_services/Support_to_children2”, “section_2_general_protection/Please_provide_more_details_on_how_restrictions_on_freedom_of_movement_have_impacted_people_in_your_community_if_you_want_to_share”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_cannot_access_needed_services_or_commodities_what_do_they_do_other_q1”, “section_2_general_protection/headed_hoh_female_above_18_no”, “section_2_general_protection/separated/Male5”, “section_2_general_protection/no_family_members_loc”, “section_3_accountability_to_AAP_community_engagement/What_kind_of_information_does_your_HH_want_to_receive_from_humanitarian_organizations_on_aid_or_services_other”, “section_2_general_protection/survivor”, “section_2_general_protection/Absence_of_state_authorities”, “section_2_general_protection/Latrines”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_document_required”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_document_required_001”, “section_2_general_protection/intend_move_current_location_other_idp_ret”, “Section_6_Referrals/referral_details_health/referral_repeat_health”, “section_2_general_protection/separated/Male13to17”, “section_2_general_protection/Market”, “section_2_general_protection/status_hh_refug”, “section_2_general_protection/status_hh_refug_ret”, “section_2_general_protection/separated/Female13to17”, “Section_5_Priority_needs_and_access_to_services/Nutrition3”, “section_2_general_protection/unaccompanied/Female5_una”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move_other”, “section_2_general_protection/headed_hoh_female_child_above_60_no”, “section_2_general_protection/Presence_of__landmines_ERW__UXOs”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive”, “Section_5_Priority_needs_and_access_to_services/Nutrition2”, “section_2_general_protection/what_are_the_reasons_for_people_in_your_location_to_feel_unsafe_other”, “section_2_general_protection/Gender_based_violence”, “section_2_general_protection/Gender_based_violence_of”, “section_2_general_protection/cause_displacement_other”, “Section_6_Referrals/referral_details_education/referral_repeat”, “Section_6_Referrals/referral_details_legal_support/referral_repeat_legal_support”, “section_2_general_protection/what_are_the_reasons_for_that”, “section_2_general_protection/what_negative_impact_has_this_had_for_your_community”, “section_2_general_protection/What_population_group_has_been_most_affected_by_this_negative_impact”, “section_2_general_protection/community_have_strategies_negative_result_of_tensions”, “section_2_general_protection/Lack_of_access_to_effective_remedy_accountability_mechanisms_for_victims_of_human_rights_violations”, “section_2_general_protection/Schools”, “Section_5_Priority_needs_and_access_to_services/Safety3”, “Section_5_Priority_needs_and_access_to_services/Safety2”, “Section_5_Priority_needs_and_access_to_services/Family_reunification3”, “section_2_general_protection/Health_Facilities”, “section_2_general_protection/Destruction_of_public_infrastructure”, “section_2_general_protection/Occupation_destruction_of_homes”, “section_2_general_protection/At_a_distribution_site”, “section_2_general_protection/Natural_disasters”, "section_2_general_protection/Worry_about_health_and_well_being_due_to_lack_of_services_and_livelihoods”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social_support3”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social_support2”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social_support1”, “Section_5_Priority_needs_and_access_to_services/Nutrition1”, “Section_5_Priority_needs_and_access_to_services/WASH1”, “Section_5_Priority_needs_and_access_to_services/Support_to_children1”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanisms_are_available_in_your_location_site_other”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major_other”, “section_2_general_protection/sources_info_location_intended_other”, “section_2_general_protection/media_sources_hh_other”, “section_2_general_protection/IF_YES_how_many_HHs_arrived_at_this_area”, “section_2_general_protection/where_did_they_come_from_country”, “section_2_general_protection/where_did_they_come_from_state”, “section_2_general_protection/where_did_they_come_from_lga”, “section_2_general_protection/where_did_they_come_from_ward”, “section_2_general_protection/where_did_they_come_from_location_displaced”, “section_2_general_protection/Please_provide_more_details_on_the_displacement”, “section_2_general_protection/Presence_of_armed_Government_forces”, “section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_or_legal_documentation_others”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members_of_your_HH_possess_others”, “section_2_general_protection/unaccompanied/Female13to17_una”, “section_2_general_protection/unaccompanied/Female5to12_una”, “section_2_general_protection/Sexual_exploitation_of_abuse_by_aid_workers”, “section_2_general_protection/other_family_members_loc”, “section_2_general_protection/intend_move_current_location_idp_refugee”, “section_2_general_protection/intend_move_preferred_destination_idp_refugee”, “section_2_general_protection/Disputes_over_land_housing_and_property”, “section_2_general_protection/Actual_secondary_occupation_of_housing_land_or_property”, “section_2_general_protection/Inter_intra_community_tensions”, “section_2_general_protection/Risk_of_human_trafficking”, “Section_6_Referrals/email_addy”, “section_2_general_protection/whom_do_people_in_your_community_report_protection_incidents_to_other”, “section_2_general_protection/Please_provide_more_details_on_the_solution_that_was_found_if_you_want_to_share”, “section_2_general_protection/requirement_move_preferred_location_other”, “section_2_general_protection/intend_move_preferred_destination_other_idp_ret”, “Section_5_Priority_needs_and_access_to_services/Legal_support1”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_impacted_people_in_your_location_other”, “section_2_general_protection/Ethnic_religious_and_or_social_discrimination”, “Section_5_Priority_needs_and_access_to_services/Support_to_women1”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of_civil_or_legal_documentation_other”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive_other”, “Section_6_Referrals/referral_details_support_to_women/referral_repeat_support_to_women”, “Section_6_Referrals/referral_details_nutrition/referral_repeat_nutrition”, “Section_6_Referrals/referral_details_support_to_children/referral_repeat_support_to_children”, “Section_6_Referrals/referral_details_wash/referral_repeat_wash”, “Section_5_Priority_needs_and_access_to_services/Safety1”, “section_2_general_protection/what_are_these_strategies_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support2”, “section_2_general_protection/IF_YES_how_many_HHs_left_this_area”, “section_2_general_protection/where_have_they_left_to_country”, “section_2_general_protection/where_have_they_left_to_state”, “section_2_general_protection/where_have_they_left_to_lga”, “section_2_general_protection/where_have_they_left_to_ward”, “section_2_general_protection/where_have_they_left_to_location_displaced”}, {“id", “formhub/uuid”, “start”, “end”, “today”, “deviceid”, “group_general_information/effective_date”, “group_general_information/country”, “group_general_information/state”, “group_general_information/LGA”, “group_general_information/WARD”, “group_general_information/location”, “group_general_information/GPS”, “group_general_information/organisation_code”, “group_general_information/organisation_11”, “group_introduction/Code_of_person”, “group_introduction/respondent_is_major”, “group_introduction/consent”, “group_introduction/language”, “section_2_general_protection/respondent_sex”, “section_2_general_protection/respondent_age”, “section_2_general_protection/C1”, “section_2_general_protection/hoh”, “section_2_general_protection/no_hoh”, “section_2_general_protection/Age”, “section_2_general_protection/C2”, “section_2_general_protection/headed_hoh_male_above_18_no”, “section_2_general_protection/Q1_header/Number”, “section_2_general_protection/Q1_header/Disaggregation_of_members_of_your_HH_that”, “section_2_general_protection/Q1_header/Less_than_5_Years_Female”, “section_2_general_protection/Q1_header/Between_18-25_Years_Female”, “section_2_general_protection/Q1_header/Less_than_5_Years_Male”, “section_2_general_protection/Q1_header/age_group_sum”, “section_2_general_protection/Q1_header/age_group_sum_children_below_17”, “section_2_general_protection/family_members_loc”, “section_2_general_protection/sep_family_members_loc”, “section_2_general_protection/una_family_members_loc”, “section_2_general_protection/are_all_school_aged_children_going_to_school”, “section_2_general_protection/status_hh”, “section_2_general_protection/dis_country”, “section_2_general_protection/dis_state”, “section_2_general_protection/dis_lga”, “section_2_general_protection/dis_ward”, “section_2_general_protection/location_hh”, “section_2_general_protection/hh_current_settlement_type”, “section_2_general_protection/current_shelter_type_1”, “section_2_general_protection/area_origin_country”, “section_2_general_protection/area_origin_state”, “section_2_general_protection/area_origin_lga”, “section_2_general_protection/area_origin_ward”, “section_2_general_protection/location_displaced”, “section_2_general_protection/when_last_displaced”, "section_2_general_protection/How_many_times_have_you_been_displaced_in_the_last”, “section_2_general_protection/what_was_the_cause_of_your_displacement”, “section_2_general_protection/red_flag_1_system”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_ret”, “section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of_di”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current_l”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current.1”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current.2”, “section_2_general_protection/How_would_you_describe_the_safety_of_your_current.3”, “section_2_general_protection/Can_people_move_around_freely_within_your_current_l”, “section_2_general_protection/Can_people_move_freely_out_of_your_current_location”, “section_2_general_protection/do_members_of_your_HH_possess_civil_and_legal_docum”, “section_2_general_protection/Do_your_HH_members_possess_documents_on_housing_lan”, "section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_or”, “section_2_general_protection/does_any_of_your_HH_members_face_any_problems_becau”, “section_2_general_protection/Has_any_member_of_your_household_experienced_any_pr”, “section_2_general_protection/Are_there_different_population_groups_present_in_yo”, “section_2_general_protection/How_would_you_describe_the_relationship_between_dis”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_informed_about_t”, "section_3_accountability_to_AAP_community_engagement/How_well_does_your_HH_feel”, “section_3_accountability_to_AAP_community_engagement/Food_assistance”, “section_3_accountability_to_AAP_community_engagement/Nutrition_assistance”, “section_3_accountability_to_AAP_community_engagement/Shelter_assistance”, “section_3_accountability_to_AAP_community_engagement/NFI_assistance”, “section_3_accountability_to_AAP_community_engagement/WASH_assistance”, “section_3_accountability_to_AAP_community_engagement/Education_assistance”, “section_3_accountability_to_AAP_community_engagement/Health_assistance”, “section_3_accountability_to_AAP_community_engagement/Services_for_GBV_survivors”, “section_3_accountability_to_AAP_community_engagement/Services_for_children_in_ne”, “section_3_accountability_to_AAP_community_engagement/Legal_services”, "section_3_accountability_to_AAP_community_engagement/Mental_Health_Psychosocial”, “section_3_accountability_to_AAP_community_engagement/Livelihood_services”, “section_3_accountability_to_AAP_community_engagement/What_kind_of_information_do”, “section_3_accountability_to_AAP_community_engagement/What_would_be_your_HHs_pref”, “section_3_accountability_to_AAP_community_engagement/Community_leaders”, “section_3_accountability_to_AAP_community_engagement/Does_your_HH_feel_that_it_i”, “section_3_accountability_to_AAP_community_engagement/Do_you_feel_the_kind_of_ser”, “section_3_accountability_to_AAP_community_engagement/Is_your_HH_aware_of_ways_to”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and_p”, “section_3_accountability_to_AAP_community_engagement/Has_your_HH_ever_used_any_o”, “section_3_accountability_to_AAP_community_engagement/did_you_receive_any_feedbac”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_peo”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_that_yo”, "Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_an”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_relationship_be”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/An_exchange_of_good_serv”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/A_sexual_activity_of_aid”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Is_your_HH_aware_of_a_me”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechanis”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Among_those_reporting_me”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/would_your_hh_feel_confi”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/report_sexual_misconduct”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Basic_material_assistanc”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Medical_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Psycho_social_support”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Legal_assistance”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Safe_shelter”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/Reintegration_in_the_com”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/DNA_paternity_identifica”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitarian”, “Section_5_Priority_needs_and_access_to_services/Priority_No_1”, “Section_5_Priority_needs_and_access_to_services/condition_1”, “Section_5_Priority_needs_and_access_to_services/NFIs1”, “Section_5_Priority_needs_and_access_to_services/Priority_No_2”, “Section_5_Priority_needs_and_access_to_services/condition_2”, “Section_5_Priority_needs_and_access_to_services/Food2”, “Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “Section_5_Priority_needs_and_access_to_services/condition_3”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training3”, “Section_6_Referrals/Does_the_HH_require_a_referral_to_service_providers”, “Section_6_Referrals/From_the_information_you_have_shared_I_can_see_that_y”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major”, “Section_6_Referrals/Comments_to_be_filled_out_by_the_protection_monitor_major”, “Section_6_Referrals/referral_details_nfis/referral_repeat_nfis”, “version”, “meta/instanceID”, “xform_id_string", “uuid", “attachments", “status", “geolocation", “submission_time", “tags", “notes", “validation_status", “submitted_by", “section_2_general_protection/Q1_header/Between_26-59_Years_Female”, “section_2_general_protection/headed_hoh_male_child_above_60_no”, “section_2_general_protection/Q1_header/Between_5-12_Years_Female”, “section_2_general_protection/headed_hoh_female_above_18”, “section_2_general_protection/Q1_header/Between_13-17_Years_Female”, “section_2_general_protection/Q1_header/Between_5-12_Years_Male”, “section_2_general_protection/Q1_header/Between_13-17_Years_Male”, "section_2_general_protection/Are_women_among_those_HH_members_who_possess_civil”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members_o”, “Section_6_Referrals/Last_name”, “Section_6_Referrals/FIrst_name”, “section_2_general_protection/Q1_header/Between_18-25_Years_Male”, “section_2_general_protection/what_are_the_reasons_for_children_not_going_to_scho”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_of”, "section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack.1”, “Section_6_Referrals/phone_num”, “section_2_general_protection/Q1_header/Between_26-59_Years_Male”, “Section_5_Priority_needs_and_access_to_services/NFIs3”, "Section_5_Priority_needs_and_access_to_services/Priority_No_1”, "Section_5_Priority_needs_and_access_to_services/Priority_No_2”, "Section_5_Priority_needs_and_access_to_services/Priority_No_3”, “section_2_general_protection/child_at_rist”, “section_2_general_protection/elderly_at_rist”, “section_2_general_protection/none_of_the_HH_members_is_vulnerable”, “Section_5_Priority_needs_and_access_to_services/Food1”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training2”, “Section_5_Priority_needs_and_access_to_services/Shelter1”, “Section_5_Priority_needs_and_access_to_services/NFIs2”, “section_2_general_protection/intend_move_current_location_idp_ret”, “section_2_general_protection/intend_move_preferred_destination_idp_ret”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move”, “section_2_general_protection/when_do_you_want_to_move_to_country”, “section_2_general_protection/when_do_you_want_to_move_to_state”, “section_2_general_protection/when_do_you_want_to_move_to_lga”, “section_2_general_protection/when_do_you_want_to_move_to_ward”, “section_2_general_protection/location_move_to”, “section_2_general_protection/intend_move_current_access_info”, “section_2_general_protection/info_hh_make_decision_preferred_location”, “section_2_general_protection/requirement_move_preferred_location”, “section_2_general_protection/sources_info_location_intended”, “section_2_general_protection/current_location_hh”, “section_2_general_protection/media_sources_hh”, “section_2_general_protection/Fredom_group_001/freedom_movement_questions_001”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_im”, “section_2_general_protection/Do_people_in_your_location_report_these_restriction”, “section_2_general_protection/Who_do_they_generally_report_these_restrictions_to”, “section_2_general_protection/when_people_in_your_community_reported_any_of_these”, “section_3_accountability_to_AAP_community_engagement/Village_elders”, “section_3_accountability_to_AAP_community_engagement/Do_you_know_of_barriers_p.1”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechan.1”, “Section_5_Priority_needs_and_access_to_services/WASH3”, “Section_5_Priority_needs_and_access_to_services/WASH2”, “Section_5_Priority_needs_and_access_to_services/Food3”, “section_3_accountability_to_AAP_community_engagement/what_ways_to_complain_and.1”, “Section_5_Priority_needs_and_access_to_services/Livelihood_vocational_training1”, “section_2_general_protection/women_at_rist”, “section_2_general_protection/what_is_your_HHs_movement_intention_idp_refugee”, "section_2_general_protection/If_your_HH_plans_to_stay_in_the_current_place_of.1”, “section_3_accountability_to_AAP_community_engagement/Religious_leaders”, “Section_5_Priority_needs_and_access_to_services/Shelter3”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_acce”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_cann”, “Section_6_Referrals/referral_details_food/referral_repeat_food”, “Section_6_Referrals/referral_details_livelihood_vocational_training/referral_rep”, “Section_6_Referrals/referral_details_shelter/referral_repeat_shelter”, “Section_5_Priority_needs_and_access_to_services/Shelter2”, “Section_6_Referrals/dob”, “Section_6_Referrals/comments”, “section_2_general_protection/requirement_move_preferred_location_other_001”, “section_2_general_protection/what_are_the_reasons_for_people_in_your_location_to”, “section_2_general_protection/Attacks_against_the_population”, “section_2_general_protection/Risk_of_abduction_and_demands_for_ransom”, “section_2_general_protection/In_which_of_the_following_locations_do_all_communit”, “section_2_general_protection/In_the_fields_when_fetching_firewood_water_scrap_me”, “section_2_general_protection/In_the_fields_when_doing_farming”, “section_2_general_protection/Does_your_community_have_strategies_to_deal_with_th”, “section_2_general_protection/when_did_the_HH_member_experience_the_protection_in”, “section_2_general_protection/type_of_incid_tookplace/type_of_incid_tookplace_que”, "section_2_general_protection/whom_do_people_in_your_community_report_protection”, “section_2_general_protection/did_the_HH_members_affected_by_the_protection_incid”, “Section_5_Priority_needs_and_access_to_services/Education3”, “section_2_general_protection/child_at_rist_school”, “section_2_general_protection/separated/Number_sep”, “section_2_general_protection/separated/Dissaggregation_of_children_within_your_H”, “section_2_general_protection/separated/Female5”, “section_2_general_protection/separated/Female5to12”, “section_2_general_protection/separated/Male5to12”, “section_2_general_protection/separated/number_separated_sum”, “section_2_general_protection/serious_med_cond”, “section_2_general_protection/are_women_among_those_possessing_HLP_documentation”, “section_2_general_protection/what_type_of_HLP_documents_do_your_HH_members_posse”, “section_2_general_protection/headed_hoh_male_child_above_60”, “section_2_general_protection/headed_hoh_male_above_18”, “section_2_general_protection/Q1_header/Above_60_Years_Female”, “section_2_general_protection/Q1_header/Above_60_Years_Male”, “section_2_general_protection/disabilities”, “section_2_general_protection/headed_hoh_female_child_above_60”, “section_2_general_protection/current_shelter_type_2”, “Section_5_Priority_needs_and_access_to_services/Education1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property3”, “Section_5_Priority_needs_and_access_to_services/Health3”, “Section_5_Priority_needs_and_access_to_services/Health2”, “Section_5_Priority_needs_and_access_to_services/Education2”, “section_2_general_protection/unaccompanied/Number_una”, “section_2_general_protection/unaccompanied/Dissaggregation_of_children_within_yo”, “section_2_general_protection/unaccompanied/Male5_una”, “section_2_general_protection/unaccompanied/number_unaccompanied_sum”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/What_should_humanitari.1”, “Section_5_Priority_needs_and_access_to_services/why_do_you_think_hhs_cannot_ac.1”, “Section_5_Priority_needs_and_access_to_services/Housing_land_and_property2”, “section_2_general_protection/In_some_blocks_of_the_camp_community”, “section_2_general_protection/Proximity”, “section_2_general_protection/Presence_of__NSAGs”, “section_2_general_protection/Criminal_activities_in_the_area”, “section_2_general_protection/In_some_streets_of_the_camp_community”, “section_2_general_protection/Within_their_house_tent”, “section_2_general_protection/what_are_these_strategies”, “section_2_general_protection/Fredom_group/freedom_movement_questions”, “Section_5_Priority_needs_and_access_to_services/Health1”, “section_2_general_protection/hh_current_settlement_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women3”, “Section_5_Priority_needs_and_access_to_services/Support_to_women2”, “Section_5_Priority_needs_and_access_to_services/Support_to_children3”, “Section_5_Priority_needs_and_access_to_services/Support_to_children2”, "section_2_general_protection/Please_provide_more_details_on_how_restrictions_on”, “Section_5_Priority_needs_and_access_to_services/if_people_in_your_community_ca.1”, “section_2_general_protection/headed_hoh_female_above_18_no”, “section_2_general_protection/separated/Male5”, “section_2_general_protection/no_family_members_loc”, "section_3_accountability_to_AAP_community_engagement/What_kind_of_information.1”, “section_2_general_protection/survivor”, “section_2_general_protection/Absence_of_state_authorities”, “section_2_general_protection/Latrines”, "section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack.2”, "section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack.3”, “section_2_general_protection/intend_move_current_location_other_idp_ret”, “Section_6_Referrals/referral_details_health/referral_repeat_health”, “section_2_general_protection/separated/Male13to17”, “section_2_general_protection/Market”, “section_2_general_protection/status_hh_refug”, “section_2_general_protection/status_hh_refug_ret”, “section_2_general_protection/separated/Female13to17”, “Section_5_Priority_needs_and_access_to_services/Nutrition3”, “section_2_general_protection/unaccompanied/Female5_una”, “section_2_general_protection/hh_intend_move_when_do_you_want_to_move_other”, “section_2_general_protection/headed_hoh_female_child_above_60_no”, “section_2_general_protection/Presence_of__landmines_ERW__UXOs”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive”, “Section_5_Priority_needs_and_access_to_services/Nutrition2”, "section_2_general_protection/what_are_the_reasons_for_people_in_your_location.1”, “section_2_general_protection/Gender_based_violence”, “section_2_general_protection/Gender_based_violence_of”, “section_2_general_protection/cause_displacement_other”, “Section_6_Referrals/referral_details_education/referral_repeat”, “Section_6_Referrals/referral_details_legal_support/referral_repeat_legal_support”, “section_2_general_protection/what_are_the_reasons_for_that”, “section_2_general_protection/what_negative_impact_has_this_had_for_your_communit”, “section_2_general_protection/What_population_group_has_been_most_affected_by_thi”, “section_2_general_protection/community_have_strategies_negative_result_of_tensio”, “section_2_general_protection/Lack_of_access_to_effective_remedy_accountability_m”, “section_2_general_protection/Schools”, “Section_5_Priority_needs_and_access_to_services/Safety3”, “Section_5_Priority_needs_and_access_to_services/Safety2”, “Section_5_Priority_needs_and_access_to_services/Family_reunification3”, “section_2_general_protection/Health_Facilities”, “section_2_general_protection/Destruction_of_public_infrastructure”, “section_2_general_protection/Occupation_destruction_of_homes”, “section_2_general_protection/At_a_distribution_site”, “section_2_general_protection/Natural_disasters”, “section_2_general_protection/Worry_about_health_and_well_being_due_to_lack_of_se”, "Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_social”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_socia.1”, “Section_5_Priority_needs_and_access_to_services/Mental_health_and_psycho_socia.2”, “Section_5_Priority_needs_and_access_to_services/Nutrition1”, “Section_5_Priority_needs_and_access_to_services/WASH1”, “Section_5_Priority_needs_and_access_to_services/Support_to_children1”, “Section_4_Protection_from_Sexual_Exploitation_and_Abuse/which_reporting_mechan.2”, “Section_6_Referrals/What_service_do_you_agree_to_be_referred_for_major_other”, “section_2_general_protection/sources_info_location_intended_other”, “section_2_general_protection/media_sources_hh_other”, “section_2_general_protection/IF_YES_how_many_HHs_arrived_at_this_area”, “section_2_general_protection/where_did_they_come_from_country”, “section_2_general_protection/where_did_they_come_from_state”, “section_2_general_protection/where_did_they_come_from_lga”, “section_2_general_protection/where_did_they_come_from_ward”, “section_2_general_protection/where_did_they_come_from_location_displaced”, “section_2_general_protection/Please_provide_more_details_on_the_displacement”, “section_2_general_protection/Presence_of_armed_Government_forces”, “section_2_general_protection/why_do_any_of_the_members_of_your_HH_lack_civil_o.1”, “section_2_general_protection/what_type_of_civil_and_legal_documents_do_members.1”, “section_2_general_protection/unaccompanied/Female13to17_una”, “section_2_general_protection/unaccompanied/Female5to12_una”, “section_2_general_protection/Sexual_exploitation_of_abuse_by_aid_workers”, “section_2_general_protection/other_family_members_loc”, “section_2_general_protection/intend_move_current_location_idp_refugee”, “section_2_general_protection/intend_move_preferred_destination_idp_refugee”, “section_2_general_protection/Disputes_over_land_housing_and_property”, “section_2_general_protection/Actual_secondary_occupation_of_housing_land_or_prop”, “section_2_general_protection/Inter_intra_community_tensions”, “section_2_general_protection/Risk_of_human_trafficking”, “Section_6_Referrals/email_addy”, “section_2_general_protection/whom_do_people_in_your_community_report_protectio.1”, “section_2_general_protection/Please_provide_more_details_on_the_solution_that_wa”, “section_2_general_protection/requirement_move_preferred_location_other”, “section_2_general_protection/intend_move_preferred_destination_other_idp_ret”, “Section_5_Priority_needs_and_access_to_services/Legal_support1”, “section_2_general_protection/how_have_the_restrictions_on_freedom_of_movement_.1”, “section_2_general_protection/Ethnic_religious_and_or_social_discrimination”, “Section_5_Priority_needs_and_access_to_services/Support_to_women1”, “section_2_general_protection/what_problems_do_HH_members_face_due_to_the_lack_.4”, “section_2_general_protection/what_kind_of_support_or_services_did_they_receive_o”, “Section_6_Referrals/referral_details_support_to_women/referral_repeat_support_to”, “Section_6_Referrals/referral_details_nutrition/referral_repeat_nutrition”, “Section_6_Referrals/referral_details_support_to_children/referral_repeat_support”, “Section_6_Referrals/referral_details_wash/referral_repeat_wash”, “Section_5_Priority_needs_and_access_to_services/Safety1”, “section_2_general_protection/what_are_these_strategies_other”, “Section_5_Priority_needs_and_access_to_services/Legal_support2”, “section_2_general_protection/IF_YES_how_many_HHs_left_this_area”, “section_2_general_protection/where_have_they_left_to_country”, “section_2_general_protection/where_have_they_left_to_state”, “section_2_general_protection/where_have_they_left_to_lga”, “section_2_general_protection/where_have_they_left_to_ward”, “section_2_general_protection/where_have_they_left_to_location_displaced”})
in
#“Expanded Column1”
Thank you in advance
I think your problem is mostly cause by the this code “#“Converted to Table” = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.Error)”, “ExtraValues.Error” this part is the reason why power query throws error. So there is two more option for this part, can you change this section with one of this code and test?
#“Converted to Table” = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore),
#“Converted to Table” = Table.FromList(results, Splitter.SplitByNothing(), null, null, ExtraValues.List),
Dear @osmanburcu ,
Thank you for your support though the missing columns have not appear yet, I tried “Accumulate into the last column” and “expanded to new rows” but I get null, see screenshot attached
Dear @osmanburcu ,
Yep to get update from you after I mentioned that I followed the procedure you suggested and still I have missing columns, I will appreciate you new update on what to do next,
Thank you and best regards
