How to read data from one excel cell into a column for all rows of a table in Qlik Sense?

[sban]

Hi Team,

I need to add one static DATE formatted value from one fixed cell of excel, into all rows under a particular  column of a table which is loaded from another excel sheet into a table in Qlik Sense.

How can I do this?

Thanks and Regards.

[Sammy_AK]

first load the fact data lets call this table A , next load the column from the excel file lets call this table B . apply a join you will get the column added to the fact filled for all rows.

example:

Tbl_A:

Load

Dept, Region, Amt

FROM [LIB://<file name>]

JOIN (Tbl_A)

Tbl_B:

Load

Trans_date

FROM [LIB://<file name>]

the output will be Dept, Region,  Amt, Trans_date