Combining Tables

[sapnasarkar]

I have two table i have common keys As Cloud in both the table but they are not primary key. How can i combine them. Is there any other way to combine to combine them.

[Ravi Gaurav]

Hello @sapnasarkar 

You can create a database view ( https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/use/reporting/concept/c_D...) 

or Functional Programming will help you like the below code :-

var table1 = 'your_table1';
var table2 = 'your_table2';
var map = {};

var gr1 = new GlideRecord(table1);
gr1.query();
while (gr1.next()) {
var cloudValue = gr1.getValue('cloud');
if (!map[cloudValue]) {
map[cloudValue] = [];
}
map[cloudValue].push(gr1);
}

var gr2 = new GlideRecord(table2);
gr2.query();
while (gr2.next()) {
var cloudValue = gr2.getValue('cloud');
if (map[cloudValue]) {
map[cloudValue].push(gr2);
}
}

[PrabhakarCh]

@sapnasarkar 

he is right. this should work.

[sapnasarkar]

@Ravi Gaurav 
I have six tables and the fields in each column is different some might be common i want if in one table it doesn't have that field  then keep empty data for that field.  Let me know how to do this and cloud field is present in all tables