The scenario is: I have a excel file AKA “abc” and need to read one row that consists of number of columns, lets say [ number of specific document.], copy single number at a time and write in AKA “xyz” excel workbook Sheet1 by checking some conditions.
We can use GET TABLE RANGE activity where mention the range of table or row and enable Is Pivot
Have a view on this for more details
Hello @Prabin_Chand ,
It would be better if you can provide some screenshot of your requirement.
If you just need to get all the data from the pivot, either you can use Read Range activity or if you need to keep the format of the Pivot then you can use Get Table Range.