Avoiding duplicate entries

[NavinReddy]

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

[MK_QSL]

It's not duplicate entries... You can see that there are three owners in first table.

[MindaugasBacius]

Apart from what is said for correct data set you should definitely use CrossTable statement.

While loading data from table use this:

[NavinReddy]

sorry i made a mistake Owner and Lob is common for all

Regards,

Niranjan

[MK_QSL]

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?

[NavinReddy]

every time i will pick only current month tier1 and tier3 as base tiers for 3months

[MK_QSL]

If you remove tier1 and tier3 column then you will get your desired output.. ( I guess)

[NavinReddy]

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

[NavinReddy]

but from data base i will get the tier1 and tier3 columns

[MindaugasBacius]

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;