Table

[Nikhil2725]

Hi Team,

I Have Table like Below.

PH9	PH9_desc	PH6	PH6_desc	PH3	PH3_desc	Div_desc
1A2791001	insulation	1A2791	insulation	1A2	Floor Heating	Diverse Trading
2A7A12001	IPS UPVC	2A7A12	Cements & CleanerIPS	2A7	Cements & CleanerIPS	KKS
2A7A12002	IPS CPVC	2A7A12	Cements & CleanerIPS	2A7	Cements & CleanerIPS	KKS
2A7A12003	IPS ABS	2A7A12	Cements & CleanerIPS	2A7	Cements & CleanerIPS	KKS
2A7A12004	Primer & Cleaner	2A7A12	Cements & CleanerIPS	2A7	Cements & CleanerIPS	KKS
2A8A16001	Simona Pressure Pipe	2A8A16	Simona	2A8	Simona	FKS
2A8A16002	Simona Butt fusion f	2A8A16	Simona	2A8	Simona	FKS
2A8A16003	Simona Socket fusion	2A8A16	Simona	2A8	Simona	FKS
2A8A16004	Special Pipe Fitting	2A8A16	Simona	2A8	Simona	FKS
2A8A16005	Liner Pipes	2A8A16	Simona	2A8	Simona	FKS
2A8A16900	Simona Rawmaterial	2A8A16	Simona	2A8	Simona	FKS
2C1C00001	CPC not all. general	2C1C00	CPC not all. general	2C1	CPC	Distribution Systems
2C1C11001	CPC meter sets	2C1C11	CPC meter sets	2C1	CPC	Distribution Systems
2C1C12001	CPC Risers	2C1C12	CPC Risers	2C1	CPC	Distribution Systems

I want to alter the table like this so that It will be helpful to me in order to make the necessary changes. Kindly Help me in this..

PH_Name	PH_value	PH_Desc	Div_desc
PH9	1A2791001	insulation	Diverse Trading
	2A7A12001	IPS UPVC	KKS
	2A7A12002	IPS UPVC	KKS
	2A7A12003	IPS ABS	KKS
	2A7A12004	Primer & Cleaner	KKS
	2A8A16001	Simona Pressure Pipe	FKS
	2A8A16002	Simona Butt fusion f	FKS
	2A8A16003	Simona Socket fusion	FKS
	2A8A16004	Special Pipe Fitting	FKS
	2A8A16005	Liner Pipes	FKS
	2A8A16900	Simona Rawmaterial	FKS
	2C1C00001	CPC not all. general	Distribution Systems
	2C1C11001	CPC meter sets	Distribution Systems
	2C1C12001	CPC Risers	Distribution Systems
PH6	1A2791	insulation	Diverse Trading
	2A7A12	Cements & CleanerIPS	KKS
	2A7A12	Cements & CleanerIPS	KKS
	2A7A12	Cements & CleanerIPS	KKS
	2A7A12	Cements & CleanerIPS	KKS
	2A8A16	Simona	FKS
	2A8A16	Simona	FKS
	2A8A16	Simona	FKS
	2A8A16	Simona	FKS
	2A8A16	Simona	FKS
	2A8A16	Simona	FKS
	2C1C00	CPC not all. general	Distribution Systems
	2C1C11	CPC meter sets	Distribution Systems
	2C1C12	CPC Risers	Distribution Systems
PH3	1A2	Floor Heating	Diverse Trading
	2A7	Cements & CleanerIPS	KKS
	2A7	Cements & CleanerIPS	KKS
	2A7	Cements & CleanerIPS	KKS
	2A7	Cements & CleanerIPS	KKS
	2A8	Simona	FKS
	2A8	Simona	FKS
	2A8	Simona	FKS
	2A8	Simona	FKS
	2A8	Simona	FKS
	2A8	Simona	FKS
	2C1	CPC	Distribution Systems
	2C1	CPC	Distribution Systems
	2C1	CPC	Distribution Systems

[Kashyap_R]

Hi
Try using CrossTable while loading

Hope it helps
Thanks

[Nikhil2725]

Hi,

Can u please send the brief step in order to use CrossTable?

I mean with the script 

Thanks.

[lorenzoconforti · Accepted solution]

Not sure a crosstable would work as you have multiple column headers to reference

I would do it this way:

Data_temp:
Load * inline [
PH9, PH9_desc, PH6, PH6_desc, PH3, PH3_desc, Div_desc
1A2791001, insulation, 1A2791, insulation, 1A2, Floor Heating, Diverse Trading
2A7A12001, IPS UPVC, 2A7A12, Cements & CleanerIPS, 2A7, Cements & CleanerIPS, KKS
2A7A12002, IPS CPVC, 2A7A12, Cements & CleanerIPS, 2A7, Cements & CleanerIPS, KKS
2A7A12003, IPS ABS, 2A7A12, Cements & CleanerIPS, 2A7, Cements & CleanerIPS, KKS
2A7A12004, Primer & Cleaner, 2A7A12, Cements & CleanerIPS, 2A7, Cements & CleanerIPS, KKS
2A8A16001, Simona Pressure Pipe, 2A8A16, Simona, 2A8, Simona, FKS
2A8A16002, Simona Butt fusion f, 2A8A16, Simona, 2A8, Simona, FKS
2A8A16003, Simona Socket fusion, 2A8A16, Simona, 2A8, Simona, FKS
2A8A16004, Special Pipe Fitting, 2A8A16, Simona, 2A8, Simona, FKS
2A8A16005, Liner Pipes, 2A8A16, Simona, 2A8, Simona, FKS
2A8A16900, Simona Rawmaterial, 2A8A16, Simona, 2A8, Simona, FKS
2C1C00001, CPC not all. general, 2C1C00, CPC not all. general, 2C1, CPC, Distribution Systems
2C1C11001, CPC meter sets, 2C1C11, CPC meter sets, 2C1, CPC, Distribution Systems
2C1C12001, CPC Risers, 2C1C12, CPC Risers, 2C1, CPC, Distribution Systems
];

MainTable:
Load
'PH9' as PH_Name,
PH9 as PH_value,
PH9_desc as PH_Desc,
Div_desc
Resident Data_temp;
Load
'PH6' as PH_Name,
PH6 as PH_value,
PH6_desc as PH_Desc,
Div_desc
Resident Data_temp;
Load
'PH3' as PH_Name,
PH3 as PH_value,
PH3_desc as PH_Desc,
Div_desc
Resident Data_temp;

drop Table Data_temp;

[Nikhil2725]

Thanks for this code..

It worked actually what I wanted..

Cheers....