ProjTransRefTransOrigTransAMOUNT208428 6295865208428 -62958662084282084286 I need LikeProjTransRefTransProjTransAmountOrigTransProjTransAmount208428YES295865-6YES2958666 if(ProjTrans in RefTrans) then YES else Noif(ProjTrans = RefTrans && OrigTrans ="Null") then ProjTransif(ProjTrans = RefTrans && OrigTrans ="Null") then Amountif(ProjTrans = OrigTrans ) then "YES" Else Noif(ProjTrans = OrigTrans ) then ProjTransif(ProjTrans = OrigTrans ) then Amount

Hi sohailstsindia You transform the data circled by blue box To one row as follows Right? Best Regards Maggie

Hi Maggie, Yes I need like that please solve this. Regards,sohailstsindia

Forum Discussion

Helper I

7 years ago

I need Like

ProjTrans	RefTrans	ProjTrans	Amount	OrigTrans	ProjTrans	Amount
208428	YES	295865	-6	YES	295866	6

	if(ProjTrans in RefTrans) then YES else No	if(ProjTrans = RefTrans && OrigTrans ="Null") then ProjTrans	if(ProjTrans = RefTrans && OrigTrans ="Null") then Amount	if(ProjTrans = OrigTrans ) then "YES" Else No	if(ProjTrans = OrigTrans ) then ProjTrans	if(ProjTrans = OrigTrans ) then Amount