Hi,
This is the input file , where i want to group on bases of two factors , one is country and one is DISC_TYPE_CD
then filter for only RQST_TYPE_CD = B. If the DISC_TYPE_CD is EX then it should write in ex sheet under respective country column and if DISC_TYPE_CD is IM then it should rite the data into im sheet in the output file.
Test.xlsx (10.0 KB)
Test_Output file.xlsx (17.0 KB)
Hi @Deeksha ,
Can you please explain the sheet part again.
Yeah Sure,
In the output File there are 3 sheets , EX, IM and G
If we group by using country and DISC_TYPE_CD then we would get 3 groups that is JP - EX , JP - IM and JP - G
next we get take only this column GROUP_DISPLAY_NM - for RPA use data and paste it into the output file , If JP EX group it should paste it under FE_JP column under EX sheet next Taking JP -IM group , take that data paste it under “FI_JP” in IM sheet
Got it. Let me update you soon.