1 of 1 people found this helpful
No need to worry , please follow the below steps and you will get the desired result.
1) First create a Join( Either by drag down or by using Custom SQL technique)
2) When A join is happening , you will see a table name is getting prefixed with the Join as per the below image.
3) Go to the sheet View and access the Field.
I am just making a Wild Guess, may be you have checked the "Group By folder Option" which is making it difficult to find.
You can just change the value to "Group By Data source Table"
5) Or follow the simplest technique of searching by field name.
if still nothing works out then Define the column name by using Custom Sql query technique.
Let me know if you still face any issue.
Rajeev pandeyFollow my Blog:
This is embarrassing, after viewing both of your posts, and realised that they should rightly be available, it dawned on me that I have hid the fields.
No wonder I couldn't locate them even after searching them as you suggested.
While the answers you provided are not exactly what resolved it, but they certainly led to the resolution. Appreciate them much!