Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts,
Good Afternoon
if can i get updated data for current month same fact id its creating for multiple entries
how to avoid this issue on script i have many fact-ids having same problem
i want to make it below format
any suggestion please not sure how to resolve this issue
Best Regards,
Niranjan
It's not duplicate entries... You can see that there are three owners in first table.
Apart from what is said for correct data set you should definitely use CrossTable statement.
While loading data from table use this:
sorry i made a mistake Owner and Lob is common for all
Regards,
Niranjan
Now Tier3 and Tier1 is different for each line.. If you will show it on single line what could be the Tier1 and Tier3 for that line?
every time i will pick only current month tier1 and tier3 as base tiers for 3months
If you remove tier1 and tier3 column then you will get your desired output.. ( I guess)
Hi Mindaugas,
i have tried with crosstable i got the 3months of tier1 and tier3 information
please guide me how to display with current month tiers having all months data
Regards,
niranjan
but from data base i will get the tier1 and tier3 columns
Is it what you are looking for?
Status:
CrossTable(Status, Data, 5)
LOAD FactID,
Lob,
Owner,
Tier3,
Tier1,
Status,
Status1,
Status2
FROM
(ooxml, embedded labels, table is Sheet1, filters(
Remove(Col, Pos(Top, 7)),
Remove(Col, Pos(Top, 8)),
Remove(Col, Pos(Top, 9))
));
Date:
CrossTable(Date, Info, 5)
LOAD FactID,
Lob,
Owner,
Tier3,
Tier1,
[Mar 16],
[Feb 16],
[Jan 16]
FROM
(ooxml, embedded labels, table is Sheet1, filters(
Remove(Col, Pos(Top, 6)),
Remove(Col, Pos(Top, 7)),
Remove(Col, Pos(Top, 8))
));
tmp:
NoConcatenate
LOAD *
Resident Status
Where Data <> '';
inner Join
LOAD *
Resident Date
Where Info <> '';
DROP Fields Status;
DROP Table Status, Date;