Forum Discussion
Return Specific value from a condition
I think you need to expand the "Output" lists.
Thank you again for looking into this. I did expanded the Output column. The error that was occured previously about the ID wasn't found is now disappeared, I can see values in the Output column when i extract or expand the column. However, Firstly, I cannot see the data or table columns as shown in the below screenshot and is the last step in my power query applied steps and secondly, the Output column is just returning everything from the list and not filtering values based on category column.
Resource Table:
not sure what you mean by "data or table columns".
Pick the ID and Output columns and do your comparisons.
Okay, so if you look at the last screenshot I provided, there is no ID column or any other column displayed from the Resource Table, it is just showing the Binary contenta and If i combine the files again, the Output column is not showing up.