Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
sban
Contributor III
Contributor III

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

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.

1 Reply
Sammy_AK
Creator II
Creator II

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