Designer

aakanksha_garg

 I am trying to create a table in excel. So i have this table A with Account, pin-code, etc.

Unique Key	Account	Bank Code	Pin- Code	Qty	Date
THY,893	THY	LD	123	-893	8/29/2023
THY,938	THY	SD	123	-938	8/17/2023
ABC,145	ABC	LD	123	-145	9/6/2023
ABC,145	ABC	LR	637	145	9/6/2023
ABC,2334	ABC	SR	123	-2334	9/6/2023
ABC,2334	ABC	LR	637	2334	9/6/2023

So i have scenarios, like for example if, Unique key matches -ABC,2334 case and Bank Code is LR & SR, then From - 637 and To - 123

Entity	Book	Security	Trade Date	Value Date	Depot From	Depot To	Quantity
Sequel	5517	ABC	9/6/2023	9/6/2023	637	123	2334

And this is how i map rest of the columns

AndrewSu

@aakanksha_garg ,  it's hard to understasnd how the data needs to transform in your example because the column headers of your 'end state' are different than the column headers of your 'start data'.  If you could provide more clarity on the logic of the transformations, that would be very helpful in resolution. 

Thanks.