Adding new row into column with changing the format.

ravikumar060987

Dear Experts, Which tool and condition, logic need to use to get the required output?

		Input
Category	Set	Item Type	Ex Type	Quantity	Available Position	Ageing
MY DATA	MY-1	SP	PSS	400000	400000	60
		Difference Quantity		400,000.000
MY DATA	MY-1	LP	BP	50000	50000	39
MY DATA	MY-1	SP	BP	50100	50000	39
		Difference Quantity		100.000

		Output
MY DATA	MY-1	SP	PSS	400000	400000	60	Difference Quantity	400,000.000
MY DATA	MY-1	LP	PB	50000	50000	39	Difference Quantity	100.000
MY DATA	MY-1	SP	PB	50100	50000	39	Difference Quantity	100.000

ShankerV

Hi @ravikumar060987 

Step 7: Join tool

Last step: Browse tool to show the output

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V