Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a 2 different data set with out any unique id match with each other. 1 does have proper dates and other do not have dates but do have month in text format.
Now I would like to see both info in single straight table.
When I apply 1 set of data in table with its =month(date) and count is shows me 1st set of data, But when I also add 2 set data by it do not give any value. reason it do not have dates to match with 1set of data.
I have attached sample data, hope is make more sense.
I not sure how could I solve it, Please help me.
Hi Dipesh,
Script:
TAB1:
LOAD
'AUDIT' AS ORIGIN,
Status,
MONTH(Date) AS MONTH,
[Audit Level],
Location
FROM
(ooxml, embedded labels, header is 1 lines, table is Sheet1)
WHERE ROWNO()<7;
CONCATENATE
LOAD
'LEARNING' AS ORIGIN,
Status1 AS Status,
Learning,
Location1 AS Location,
MONTH(DATE(DATE#(Month,'MMM'),'MMM')) AS MONTH
FROM
(ooxml, embedded labels, header is 1 lines, table is Sheet1)
WHERE ROWNO()<15;
-----------------------------------------------------------------------------------------------------------------------