Transpose export option for LQAS data

[bnygren]

LQAS_transposed_comparison.xlsx Situation: Users make use of LQAS data in long format (numbered by house). They currently format outside of APMIS.

Solution: In campaign data, LQAS data should have a button for exporting as long format (transposed). See template below of header structure for long format.

WIDE	Campaigns	Form	Region	RCode	Province	PCode	District	DCode	Cluster	Cluster Number	CCode	Form Phase	Source	Creating user	Verified Status	Published Status	LQAS Cluster Form	Name of Surveyor	Lot Number	Village Name	Village Code (Ten Digits)	Cluster Name	Lot Cluster Number	Date		Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	Total number of children (0-59 months) seen in this household	Age of selected child in months (0-59)	Gender	Is finger marked for OPV?	Reason if finger is not marked	If any area/household are not visited, please write down the location and reasons	test
WIDE	campaign	form	region	rcode	province	pcode	district	dcode	Cluster	clusternumber	ccode	formType	source	creatingUser	isverified	ispublished	LQAS_Cluster_Form	Surveyor	LotNo	Village	villagecode	CName	LotClusterNo	VisitDate		House1	childrenAgeH1	GenderH1	FMH1	ReasonsH1	House2	childrenAgeH2	GenderH2	FMH2	ReasonsH2	House3	childrenAgeH3	GenderH3	FMH3	ReasonsH3	House4	childrenAgeH4	GenderH4	FMH4	ReasonsH4	House5	childrenAgeH5	GenderH5	FMH5	ReasonsH5	House6	childrenAgeH6	GenderH6	FMH6	ReasonsH6	House7	childrenAgeH7	GenderH7	FMH7	ReasonsH7	House8	childrenAgeH8	GenderH8	FMH8	ReasonsH8	House9	childrenAgeH9	GenderH9	FMH9	ReasonsH9	House10	childrenAgeH10	GenderH10	FMH10	ReasonsH10	Comment	test
LONG	Campaigns	Form	Region	RCode	Province	PCode	District	DCode	Cluster	Cluster Number	CCode	Form Phase	Source	Creating user	isverified	ispublished	LQAS_Cluster_Form	Name of Surveyor	Lot Number	Village Name	Village Code (Ten Digits)	Cluster Name	Lot Cluster Number	Date	House #	# of Living	Age	Sex	Fingermarked_Yes/No	Reason
																									H1
																									H2
																									H3

LQAS_transposed_comparison.xlsx

[bnygren]

per @DevSeg one solution maybe adding prefixes to field names to allow for IDing the fields to transpose. Will also need to account for historical data. We will revisit at next dev meeting

[bnygren]

Please see attached comparison in issue description of export data long format against wide with a few issues noted.