I have this input excel file shown as below-
And my output should be-
Can you please help me?
Regards,
Nirmalya Sarkar
I have this input excel file shown as below-
And my output should be-
Can you please help me?
Regards,
Nirmalya Sarkar
Hi @nirmalya.sarkar ,
You can try below steps
1 - Read whole excel from Read range activity and pass range as “B4”
2 - Take filter data table activity and pass condition as shown below
3 - Use write range activity to paste data on respective sheet.
Please follow the steps and let me know if you face any issue.
I don’t have xaml ready with me.
Hi @ermanoj3101 ,
Excel_Automation.xaml (6.7 KB)
After doing this, it shows an error.
‘Column name’ is not set or invalid. But I copy and paste those column names in my workflow.
Also I am sharing my excel file.
ProjectDemo.xlsx (12.0 KB)
Regards,
Nirmalya Sarkar
Does your headers always contain spaces ?
If so then you can use above attached xaml.
@ermanoj3101 , no …this is the first time I face this issue. I did many projects with filter data table. But this type of problem never came.
Anyway, Thanks a lot.
Regards,
Nirmalya Sarkar.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.