https://community.qlik.com/t5/Talend-Studio/Rearrange-2-Dimensional-Data-to-3-Dimensional/m-p/2340591#M108609 <P>As the topic mentioned. Example data from 2 dimensional excel data</P> <P>SalesInvNo | InvDate &nbsp;| ItemNo &nbsp;| ItemName | UnitPrice | VAT | InvAmount | CustomerName | CustAdd</P> <P>0001 &nbsp;| &nbsp;12-7-17 &nbsp;| &nbsp;A01 &nbsp;| WoodenTable &nbsp;| &nbsp;200 &nbsp;| &nbsp;20 &nbsp;| &nbsp;440 &nbsp;| &nbsp;ABC,Ltd &nbsp;| &nbsp;XYZ</P> <P><SPAN>0001 &nbsp;| &nbsp;12-7-17 &nbsp;| &nbsp;A02 &nbsp;| WoodenChair &nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;| &nbsp;440 &nbsp;| &nbsp;ABC,Ltd&nbsp;&nbsp;| &nbsp;XYZ</SPAN></P> <P><SPAN>0001 &nbsp;| &nbsp;12-7-17 &nbsp;| &nbsp;A01 &nbsp;| GarbageBin &nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;| &nbsp;440&nbsp;&nbsp;| &nbsp;ABC,Ltd&nbsp;&nbsp;| &nbsp;XYZ</SPAN></P> <P>&nbsp;</P> <P><SPAN>I want to Convert it to 3 dimensional excel data</SPAN></P> <P><SPAN>0001 | &nbsp;ABC,Ltd &nbsp;| &nbsp;XYZ</SPAN></P> <P><SPAN>A01 &nbsp;| WoodenTable &nbsp;| &nbsp;200 &nbsp;| &nbsp;20 &nbsp;</SPAN></P> <P><SPAN>A02 &nbsp;| WoodenChair&nbsp;&nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;</SPAN></P> <P><SPAN>A01 &nbsp;| GarbageBin &nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;</SPAN></P> <P><SPAN>12-7-17 | 440</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 12 Sep 2017 14:51:35 GMT Anonymous 2017-09-12T14:51:35Z https://community.qlik.com/t5/Talend-Studio/Rearrange-2-Dimensional-Data-to-3-Dimensional/m-p/2340591#M108609 <P>As the topic mentioned. Example data from 2 dimensional excel data</P> <P>SalesInvNo | InvDate &nbsp;| ItemNo &nbsp;| ItemName | UnitPrice | VAT | InvAmount | CustomerName | CustAdd</P> <P>0001 &nbsp;| &nbsp;12-7-17 &nbsp;| &nbsp;A01 &nbsp;| WoodenTable &nbsp;| &nbsp;200 &nbsp;| &nbsp;20 &nbsp;| &nbsp;440 &nbsp;| &nbsp;ABC,Ltd &nbsp;| &nbsp;XYZ</P> <P><SPAN>0001 &nbsp;| &nbsp;12-7-17 &nbsp;| &nbsp;A02 &nbsp;| WoodenChair &nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;| &nbsp;440 &nbsp;| &nbsp;ABC,Ltd&nbsp;&nbsp;| &nbsp;XYZ</SPAN></P> <P><SPAN>0001 &nbsp;| &nbsp;12-7-17 &nbsp;| &nbsp;A01 &nbsp;| GarbageBin &nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;| &nbsp;440&nbsp;&nbsp;| &nbsp;ABC,Ltd&nbsp;&nbsp;| &nbsp;XYZ</SPAN></P> <P>&nbsp;</P> <P><SPAN>I want to Convert it to 3 dimensional excel data</SPAN></P> <P><SPAN>0001 | &nbsp;ABC,Ltd &nbsp;| &nbsp;XYZ</SPAN></P> <P><SPAN>A01 &nbsp;| WoodenTable &nbsp;| &nbsp;200 &nbsp;| &nbsp;20 &nbsp;</SPAN></P> <P><SPAN>A02 &nbsp;| WoodenChair&nbsp;&nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;</SPAN></P> <P><SPAN>A01 &nbsp;| GarbageBin &nbsp;| &nbsp;100 &nbsp;| &nbsp;10 &nbsp;</SPAN></P> <P><SPAN>12-7-17 | 440</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 12 Sep 2017 14:51:35 GMT https://community.qlik.com/t5/Talend-Studio/Rearrange-2-Dimensional-Data-to-3-Dimensional/m-p/2340591#M108609 Anonymous 2017-09-12T14:51:35Z https://community.qlik.com/t5/Talend-Studio/Rearrange-2-Dimensional-Data-to-3-Dimensional/m-p/2340592#M108610 <P>Can you explain how you got from the first table to the second table? I can see the patterns, but I can also see other ways in which the data could be grouped which make as much sense as what we see in your second table. I am sure Talend can do this, but we will need some rules to work with.</P> Tue, 12 Sep 2017 23:04:20 GMT https://community.qlik.com/t5/Talend-Studio/Rearrange-2-Dimensional-Data-to-3-Dimensional/m-p/2340592#M108610 Anonymous 2017-09-12T23:04:20Z