Issue with date mapping

[qv_testing]

Hi Community,

I have Employee table(Manual report, someone entering the data), by default Employee table associating with EmpID to main table,

My requirement

few data not mapping because few data not associating Date level, but I have to show all records for all months.

My Idea, can we create one derived column for all the months in the script level, then I can map EmpID & Date key??

Example:    Jan 2018 full data set, Feb 2018 full data set  and so on....... till Dec 2018

EmpID	Cost	EmpName	Date (Derived Column)
1000	275	Adrian Dobson	Jan 2018
1001	550	Alan Grant	Jan 2018
1002	386	Alison Levermore	Jan 2018
1003	375	Andy North	Jan 2018
1004	221	Antony Powell	Jan 2018
1005	699	Charles Cowling	Jan 2018
1006	154	Chris O'Hare	Jan 2018
1007	245	Craig Walker	Jan 2018
1008	252	David Carter	Jan 2018
1009	0	Daniel Jarman	Jan 2018
1010	391	David Bennett	Jan 2018
1011	206	Deepa Gajparia	Jan 2018

Please could you give suggestion Experts ??

Thanks In Advance.....

[kfoudhaily]

what is the rule to determine(calculate) this column: Date (Derived Column)?

[qv_testing]

I have Employee table, they are entering manually, so I don't have date field. (No rules)

I'm fetching only EmpName in this table, calculation fields coming from different tables.

Just I have to loop all the Year and Month level data.... like above mentioned

[qv_testing]

Experts!! is there any possibility like full data set loop..

Please suggest

[marcus_sommer]

You could do something like this:

for i = 1 to 12

     t: load EmpID, Cost, EmpName, $(i) as Month from Excel;

next

But creating a key of EmpID and Month is only useful if there are appropriate data within your other tables ..

- Marcus