Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can you please let me know what is the steps to create reports and dashboards.
and
How can i join 2 tables (Left out)
I have 2 tables A and B. .
Thanks
Govind
join will make two tables into single table. change the field names in second table into first table name(similar names)
1.creating dashboards is purely based on requirement only.
2. Table1:
load a
b
c
from table1;
left join(Table1)
Table2:
load a
b
b
from table2;
How and where can i give this condition.I am new to sense can you please give me steps
go to data load editor and use above query
[GL_Fact]:
LOAD
[Expense_GL] AS [Expense_GL],
[Posted Date] AS [Posted Date-Year];
LOAD [Expense_GL],
[Posted Date]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is GL_Fact);
Left join [GL_Fact]
[Expenses_Fact]:
LOAD
[Expense_Ex] AS [Expense_Ex],
[Year] AS [Posted Date-Year];
LOAD [Expense_Ex],
[Year]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is Expenses_Fact);
I am getting error..
[GL_Fact]:
LOAD
[Expense_GL] AS [Expense_GL],
[Posted Date] AS [Posted Date-Year];
LOAD [Expense_GL],
[Posted Date]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is GL_Fact);
Left join
[Expenses_Fact]:
LOAD
[Expense_Ex] AS [Expense_Ex],
[Year] AS [Posted Date-Year];
LOAD [Expense_Ex],
[Year]
FROM [lib://Datasources/Expense_Report.xlsx]
(ooxml, embedded labels, table is Expenses_Fact);
Now looks ok but in my data model viewer I can see single table instead of 2 tables.but I can see both tables fields.
join will make two tables into single table. change the field names in second table into first table name(similar names)