Create data island in backend

[prma7799]

Dear All,

I have one build application based on concatenate now i want to add three more tables in existing application and calendar also but i don't want to create any synthetic key or circular loop because in this new table have 90% same column as existing table.

Can anyone help me out?

Thanks...

[kaushiknsolanki]

Hi,

Then you can concatenate those new 3 table to the existing one.

What is the problem?

Regards,

Kaushik Solanki

[prma7799]

Hi Kaushik,

Thanks for your quick reply. 

Actually when i try to concatenate SalesInvoice and Shipment table in existing data model then getting some difference values.

Thanks

[kaushiknsolanki]

Right you may not get it correct.

You need the link table, which will help you to connect them.

Concatenate vs Link Table

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

What is Link Tables? What is the use?

Regards,

Kaushik Solanki

[prma7799]

Hi Kaushik,

I got what was the problem...

I have already created the data island but due to case sensitive i am getting exact values ..

I have wrote like this

SUM({$<sl.DT={1}, sl.Order_Flag={'P'}>}SL.Sales)

Just corrected

SUM({$<SL.DT={1}, SL.Order_Flag={'P'}>}SL.Sales)

Thanks

[its_anandrjs]

Hi,

You got it, but i suggested you can you please use composite keys or key field values while connecting two tables by left Joining or concatenate those tables depends on your result and out put by that tables.

Hope this helps

Regards

Anand