VLookup in reports

[Poorva Bhawsar]

Hi Community,

If there is vlookup applied in excel, then how to create reports for this? Is there any functionality related to vlookups in servicenow?

Thanks,

Poorva Bhawsar

[Dr Atul G- LNG · Accepted solution]

Hi @Poorva Bhawsar 

Now you bring the real use case 😀

So now it come to SN, and lets see in which tables these 2 records get stored are in same table or 2 different table?

It is like like I want SLA and Incident records where inc record exits in SLA table. 

1st Get the both field table

Then see is it same or 2 different table

3rd , how these 2 tables related like as related list or what

Create DB view or use standard reporting ( if Related list is the case ) and get the result.

[Poorva Bhawsar]

Thanks for the clarity. I was getting confused with the word vlookup and was trying to search for the solution on the same. You are correct we will go ahead and create database views accordingly to join these tables and to get that column's data separately. Even i was thinking same to use the database views.

[Dr Atul G- LNG]

No problem @Poorva Bhawsar 

Its all about learning from each other and growing together. Please share feedback once its done 

[Poorva Bhawsar]

Its a very big requirement starting from an integration and pulling data into servicenow and post that creating few PA reports  which are formula based.

[Dr Atul G- LNG]

Divide and build. It look complex but when you divide this in parts, then it will be easy.