Forum Discussion
How to query multiple columns for data without filters
Scenerio: Each physician in the U.S. is required to be credentialed (a.k.a. - Approved) by an insurance carrier prior to submitting charges for service. Our Credentialling Department wants a report...
Ashish, This is the EXACT result that I was hoping for! Thanks you so very much! Now....Since my data is being modified weekly, can you tell me how you created this table, and how it will link to my existing data that I pull from SharePoint each week? If I am correct in my assumption, either I will need to add these 3 columns to my existing table or I will need to build a second table (both of which will require a bit more direction from you if possible). Thanks
For other beginners I will add a bit of detail on the process as the Applied Steps were pretty simplistic given the modificatins I'd made to my sample data. So if starting from scratch:
- I opened query editor and duplicated my original table
- I went to Choose Columns and of the 78, kept only the 22 that I needed. (20 contained the name of the vendors with their status, 1 was an id field and the last was the full name of the employee)
- I then highlighted the ID and Name fields, the 'unpivoted other columns'
- This left me with the desired 4 columns as shown in the sample pbx.
Thanks again Ashish!