Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

My Data Table: How do I link the date.

Hello, please check out my datastructure.

export.png

I want to use the 'Datum' table with the dates also for StockDetails. How can I use the datum table for both tables?

MonthlyStockFinal contains a summary of the StockDetails for the end of each month. in StockDetails the StockDate field contains the date.

1 Solution

Accepted Solutions
Not applicable
Author

You can create a new fıeld with "date+keypart"  in both stockdetails and monthlystokdinal tables.

View solution in original post

3 Replies
Not applicable
Author

Hi

In ur stockdetails table create "Date" field

Then stockDetails table directly link to Datum table.

see below..........

StockDetails:

Load

..

..

KeyPart As %KeyPart,

StockDate

StockDate as Date

From.....

MonthlyStockFinal:

Load

Date As %date,

KeyPart As %KeyPart,

KeyPart,

EndOfMonthStock

From....

Not applicable
Author

I tried this but I get Syn keys. Because of KeyPart

Not applicable
Author

You can create a new fıeld with "date+keypart"  in both stockdetails and monthlystokdinal tables.