https://community.qlik.com/t5/App-Development/Transpose-Columns-into-Rows-and-Add-name/m-p/1755987#M58304 <P>Hello Experts, I want to create a table that looks like this:&nbsp;</P><P>Program Change Summary ($ in Millions)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Prior Year Current Year&nbsp;<BR />Previous President's Budget&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 383.322&nbsp; &nbsp;356.107&nbsp;<BR />Current President's Budget&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 374.047&nbsp; &nbsp; 356.107&nbsp;<BR />Total Adjustments&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-9.275&nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp;<BR />&nbsp;Congressional General Reductions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp; &nbsp; 0.000<BR />&nbsp;Congressional Directed Reductions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.000&nbsp; &nbsp; &nbsp; &nbsp; 0.000<BR />&nbsp;Congressional Rescissions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp; &nbsp;0.000<BR />&nbsp;Congressional Adds&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp; 0.000<BR />&nbsp;Congressional Directed Transfers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.000&nbsp; &nbsp; &nbsp; 0.000<BR /><BR /></P><P>Right now when&nbsp; I load the data it has columns like this:&nbsp;</P><P>[ChangeSummary/AdjustmentDetails/SBIRSTTRTransfer/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/SBIRSTTRTransfer/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/Reprogrammings/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/Reprogrammings/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedTransfers/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedTransfers/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalAdds/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalAdds/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalRescissions/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalRescissions/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedReductions/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedReductions/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalGeneralReductions/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalGeneralReductions/CurrentYear]</P><P>&nbsp;</P><P>I tried to do a crosstable to transpose the data but I am not sure thats the right thing. I need to pull out the Labels because right now there isn't a column that has (Program Change Summary ($ in Millions)&nbsp;&nbsp;<BR />Previous President's Budget&nbsp;,Current President's Budget,Total Adjustments,&nbsp;Congressional General Reductions&nbsp;,Congressional Directed Reductions,&nbsp;Congressional Rescissions,&nbsp;Congressional Adds&nbsp;,&nbsp;Congressional Directed Transfers) as values.&nbsp;I want to make those rows and then have the values be columns.</P><P>Sorry I a new to the data load editor and this seems very complex. I hope this makes sense.&nbsp;</P> Sat, 16 Nov 2024 17:55:19 GMT heathqm 2024-11-16T17:55:19Z https://community.qlik.com/t5/App-Development/Transpose-Columns-into-Rows-and-Add-name/m-p/1755987#M58304 <P>Hello Experts, I want to create a table that looks like this:&nbsp;</P><P>Program Change Summary ($ in Millions)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Prior Year Current Year&nbsp;<BR />Previous President's Budget&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 383.322&nbsp; &nbsp;356.107&nbsp;<BR />Current President's Budget&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 374.047&nbsp; &nbsp; 356.107&nbsp;<BR />Total Adjustments&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-9.275&nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp;<BR />&nbsp;Congressional General Reductions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp; &nbsp; 0.000<BR />&nbsp;Congressional Directed Reductions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.000&nbsp; &nbsp; &nbsp; &nbsp; 0.000<BR />&nbsp;Congressional Rescissions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp; &nbsp;0.000<BR />&nbsp;Congressional Adds&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.000&nbsp; &nbsp; &nbsp; 0.000<BR />&nbsp;Congressional Directed Transfers&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0.000&nbsp; &nbsp; &nbsp; 0.000<BR /><BR /></P><P>Right now when&nbsp; I load the data it has columns like this:&nbsp;</P><P>[ChangeSummary/AdjustmentDetails/SBIRSTTRTransfer/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/SBIRSTTRTransfer/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/Reprogrammings/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/Reprogrammings/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedTransfers/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedTransfers/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalAdds/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalAdds/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalRescissions/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalRescissions/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedReductions/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalDirectedReductions/CurrentYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalGeneralReductions/PriorYear],<BR />[ChangeSummary/AdjustmentDetails/CongressionalGeneralReductions/CurrentYear]</P><P>&nbsp;</P><P>I tried to do a crosstable to transpose the data but I am not sure thats the right thing. I need to pull out the Labels because right now there isn't a column that has (Program Change Summary ($ in Millions)&nbsp;&nbsp;<BR />Previous President's Budget&nbsp;,Current President's Budget,Total Adjustments,&nbsp;Congressional General Reductions&nbsp;,Congressional Directed Reductions,&nbsp;Congressional Rescissions,&nbsp;Congressional Adds&nbsp;,&nbsp;Congressional Directed Transfers) as values.&nbsp;I want to make those rows and then have the values be columns.</P><P>Sorry I a new to the data load editor and this seems very complex. I hope this makes sense.&nbsp;</P> Sat, 16 Nov 2024 17:55:19 GMT https://community.qlik.com/t5/App-Development/Transpose-Columns-into-Rows-and-Add-name/m-p/1755987#M58304 heathqm 2024-11-16T17:55:19Z https://community.qlik.com/t5/App-Development/Transpose-Columns-into-Rows-and-Add-name/m-p/1755992#M58305 <P><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/125673">@heathqm</a>&nbsp; would you be able to share sample file with some data?</P> Mon, 26 Oct 2020 16:01:00 GMT https://community.qlik.com/t5/App-Development/Transpose-Columns-into-Rows-and-Add-name/m-p/1755992#M58305 Kushal_Chawda 2020-10-26T16:01:00Z https://community.qlik.com/t5/App-Development/Transpose-Columns-into-Rows-and-Add-name/m-p/1755996#M58306 <P>It is an xml file but here is a small sample file</P><P>&nbsp;</P> Mon, 26 Oct 2020 16:08:40 GMT https://community.qlik.com/t5/App-Development/Transpose-Columns-into-Rows-and-Add-name/m-p/1755996#M58306 heathqm 2020-10-26T16:08:40Z